1. 18 5月, 2006 11 次提交
  2. 17 5月, 2006 1 次提交
  3. 14 5月, 2006 2 次提交
  4. 13 5月, 2006 2 次提交
  5. 12 5月, 2006 4 次提交
  6. 11 5月, 2006 1 次提交
    • T
      Clean up code associated with updating pg_class statistics columns · 3fdeb189
      Tom Lane 提交于
      (relpages/reltuples).  To do this, create formal support in heapam.c for
      "overwrite" tuple updates (including xlog replay capability) and use that
      instead of the ad-hoc overwrites we'd been using in VACUUM and CREATE INDEX.
      Take the responsibility for updating stats during CREATE INDEX out of the
      individual index AMs, and do it where it belongs, in catalog/index.c.  Aside
      from being more modular, this avoids having to update the same tuple twice in
      some paths through CREATE INDEX.  It's probably not measurably faster, but
      for sure it's a lot cleaner than before.
      3fdeb189
  7. 10 5月, 2006 4 次提交
  8. 08 5月, 2006 2 次提交
    • B
      Build server libpgport with all non-FRONTEND object files. This is to · 3cd77da3
      Bruce Momjian 提交于
      fix a Win32 bug where pipe.c included a file that used FRONTEND, but it
      wasn't on the server-build list.
      3cd77da3
    • T
      Rewrite btree vacuuming to fold the former bulkdelete and cleanup operations · 5749f6ef
      Tom Lane 提交于
      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
  9. 07 5月, 2006 5 次提交
    • T
      Rewrite btree index scans to work a page at a time in all cases (both · 09cb5c0e
      Tom Lane 提交于
      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
    • B
    • B
      Add description: · 5ff2838c
      Bruce Momjian 提交于
      * %Disallow changing DEFAULT expression of a SERIAL column?
      
      >
      >   This should be done only if the existing SERIAL problems cannot be
      >   fixed.
      >
      5ff2838c
    • B
      Recommend more clearly custom pg_dump format over tar, buy showing · d9d2d915
      Bruce Momjian 提交于
      custom format examples first.
      d9d2d915
    • B
      Document SSL CRL usage by libpq. · bcf860b7
      Bruce Momjian 提交于
      bcf860b7
  10. 06 5月, 2006 6 次提交
  11. 05 5月, 2006 2 次提交