1. 26 Nov, 2008 12 commits
  2. 25 Nov, 2008 5 commits
  3. 24 Nov, 2008 4 commits
  4. 23 Nov, 2008 1 commit
    • Tom Lane's avatar
      Teach RequestCheckpoint() to wait and retry a few times if it can't signal · 6f6a6d8b
      Tom Lane authored
      the bgwriter immediately.  This covers the case where the bgwriter is still
      starting up, as seen in a recent buildfarm failure.  In future it might also
      assist with clean recovery after a bgwriter termination and restart ---
      right now the postmaster treats early bgwriter exit as a system crash,
      but that might not always be so.
      6f6a6d8b
  5. 22 Nov, 2008 1 commit
    • Tom Lane's avatar
      Switch the planner over to treating qualifications of a JOIN_SEMI join as · 8309d006
      Tom Lane authored
      though it is an inner rather than outer join type.  This essentially means
      that we don't bother to separate "pushed down" qual conditions from actual
      join quals at a semijoin plan node; which is okay because the restrictions of
      SQL syntax make it impossible to have a pushed-down qual that references the
      inner side of a semijoin.  This allows noticeably better optimization of
      IN/EXISTS cases than we had before, since the equivalence-class machinery can
      now use those quals.  Also fix a couple of other mistakes that had essentially
      disabled the ability to unique-ify the inner relation and then join it to just
      a subset of the left-hand relations.  An example case using the regression
      database is
      
      select * from tenk1 a, tenk1 b
      where (a.unique1,b.unique2) in (select unique1,unique2 from tenk1 c);
      
      which is planned reasonably well by 8.3 and earlier but had been forcing a
      cartesian join of a/b in CVS HEAD.
      8309d006
  6. 21 Nov, 2008 7 commits
  7. 20 Nov, 2008 8 commits
  8. 19 Nov, 2008 2 commits
    • Peter Eisentraut's avatar
      Add WITH as a refname to the SELECT reference page. · 50548676
      Peter Eisentraut authored
      Now "\help WITH" works and there will be a separate WITH(7) man page.
      50548676
    • Heikki Linnakangas's avatar
      Rethink the way FSM truncation works. Instead of WAL-logging FSM · 33960006
      Heikki Linnakangas authored
      truncations in FSM code, call FreeSpaceMapTruncateRel from smgr_redo. To
      make that cleaner from modularity point of view, move the WAL-logging one
      level up to RelationTruncate, and move RelationTruncate and all the
      related WAL-logging to new src/backend/catalog/storage.c file. Introduce
      new RelationCreateStorage and RelationDropStorage functions that are used
      instead of calling smgrcreate/smgrscheduleunlink directly. Move the
      pending rel deletion stuff from smgrcreate/smgrscheduleunlink to the new
      functions. This leaves smgr.c as a thin wrapper around md.c; all the
      transactional stuff is now in storage.c.
      
      This will make it easier to add new forks with similar truncation logic,
      like the visibility map.
      33960006