1. 19 May, 2006 2 commits
  2. 18 May, 2006 14 commits
  3. 17 May, 2006 6 commits
  4. 13 May, 2006 2 commits
  5. 12 May, 2006 2 commits
  6. 11 May, 2006 4 commits
  7. 10 May, 2006 3 commits
  8. 09 May, 2006 2 commits
  9. 08 May, 2006 2 commits
    • Bruce Momjian's avatar
      Build server libpgport with all non-FRONTEND object files. This is to · 3cd77da3
      Bruce Momjian authored
      fix a Win32 bug where pipe.c included a file that used FRONTEND, but it
      wasn't on the server-build list.
      3cd77da3
    • Tom Lane's avatar
      Rewrite btree vacuuming to fold the former bulkdelete and cleanup operations · 5749f6ef
      Tom Lane authored
      into a single mostly-physical-order scan of the index.  This requires some
      ticklish interlocking considerations, but should create no material
      performance impact on normal index operations (at least given the
      already-committed changes to make scans work a page at a time).  VACUUM
      itself should get significantly faster in any index that's degenerated to a
      very nonlinear page order.  Also, we save one pass over the index entirely,
      except in the case where there were no deletions to do and so only one pass
      happened anyway.
      
      Original patch by Heikki Linnakangas, rework by Tom Lane.
      5749f6ef
  10. 07 May, 2006 2 commits
    • Tom Lane's avatar
      Rewrite btree index scans to work a page at a time in all cases (both · 09cb5c0e
      Tom Lane authored
      btgettuple and btgetmulti).  This eliminates the problem of "re-finding" the
      exact stopping point, since the stopping point is effectively always a page
      boundary, and index items are never moved across pre-existing page boundaries.
      A small penalty is that the keys_are_unique optimization is effectively
      disabled (and, therefore, is removed in this patch), causing us to apply
      _bt_checkkeys() to at least one more tuple than necessary when looking up a
      unique key.  However, the advantages for non-unique cases seem great enough to
      accept this tradeoff.  Aside from simplifying and (sometimes) speeding up the
      indexscan code, this will allow us to reimplement btbulkdelete as a largely
      sequential scan instead of index-order traversal, thereby significantly
      reducing the cost of VACUUM.  Those changes will come in a separate patch.
      
      Original patch by Heikki Linnakangas, rework by Tom Lane.
      09cb5c0e
    • Bruce Momjian's avatar
  11. 06 May, 2006 1 commit
    • Bruce Momjian's avatar
      Add description: · 5ff2838c
      Bruce Momjian authored
      * %Disallow changing DEFAULT expression of a SERIAL column?
      
      >
      >   This should be done only if the existing SERIAL problems cannot be
      >   fixed.
      >
      5ff2838c