1. 26 Mar, 2009 5 commits
  2. 25 Mar, 2009 9 commits
  3. 24 Mar, 2009 4 commits
    • Tom Lane's avatar
      Install a search tree depth limit in GIN bulk-insert operations, to prevent · e5efda44
      Tom Lane authored
      them from degrading badly when the input is sorted or nearly so.  In this
      scenario the tree is unbalanced to the point of becoming a mere linked list,
      so insertions become O(N^2).  The easiest and most safely back-patchable
      solution is to stop growing the tree sooner, ie limit the growth of N.  We
      might later consider a rebalancing tree algorithm, but it's not clear that
      the benefit would be worth the cost and complexity.  Per report from Sergey
      Burladyan and an earlier complaint from Heikki.
      
      Back-patch to 8.2; older versions didn't have GIN indexes.
      e5efda44
    • Tom Lane's avatar
    • Tom Lane's avatar
      Implement "fastupdate" support for GIN indexes, in which we try to accumulate · ff301d6e
      Tom Lane authored
      multiple index entries in a holding area before adding them to the main index
      structure.  This helps because bulk insert is (usually) significantly faster
      than retail insert for GIN.
      
      This patch also removes GIN support for amgettuple-style index scans.  The
      API defined for amgettuple is difficult to support with fastupdate, and
      the previously committed partial-match feature didn't really work with
      it either.  We might eventually figure a way to put back amgettuple
      support, but it won't happen for 8.4.
      
      catversion bumped because of change in GIN's pg_am entry, and because
      the format of GIN indexes changed on-disk (there's a metapage now,
      and possibly a pending list).
      
      Teodor Sigaev
      ff301d6e
    • Peter Eisentraut's avatar
      Fix my typo · 9987f660
      Peter Eisentraut authored
      9987f660
  4. 23 Mar, 2009 6 commits
  5. 22 Mar, 2009 5 commits
    • Tom Lane's avatar
      Add isExtend to the parameters of the buffer_read_start and buffer_read_done · 44023dc5
      Tom Lane authored
      DTrace probes, so that ordinary reads can be distinguished from relation
      extension operations.  Move buffer_read_start probe to before the
      smgrnblocks() call that's needed in the isExtend case, since really that step
      should be charged as part of the time needed for the extension operation.
      (This makes it slightly harder to match the read_start with the associated
      read_done, since now you can't match them on blockNumber, but it should still
      be possible since isExtend operations on the same relation can never be
      interleaved.)  Per recent discussion.
      
      In passing, add the page identity (forkNum/blockNum) to the parameters of the
      buffer_flush_start/buffer_flush_done probes, which were unaccountably lacking
      the info.
      44023dc5
    • Bruce Momjian's avatar
      Clarify 'cert' authentication documention. · f04ee704
      Bruce Momjian authored
      f04ee704
    • Tom Lane's avatar
      Clean up pg_SSPI_error() coding a little bit: make the messages more · 727ffa1d
      Tom Lane authored
      consistent, translate where intended, const-ify declarations.
      Resolves a gripe from Alvaro as well as some stuff I didn't like.
      727ffa1d
    • Tom Lane's avatar
      Remove the -d and -D options of pg_dump and pg_dumpall. The functionality · 5698f6b9
      Tom Lane authored
      is still available, but you must now write the long equivalent --inserts
      or --column-inserts.  This change is made to eliminate confusion with the
      use of -d to specify a database name in most other Postgres client programs.
      Original patch by Greg Mullane, modified per subsequent discussion.
      5698f6b9
    • Tom Lane's avatar
      Remove the datetime keywords ABSTIME and RELTIME, which we'd been treating as · 0fd85d78
      Tom Lane authored
      noise words for the last twelve years, for compatibility with Berkeley-era
      output formatting of the special INVALID values for those datatypes.
      Considering that the datatypes themselves have been deprecated for awhile,
      this is taking backwards compatibility a little far.  Per gripe from Josh
      Berkus.
      0fd85d78
  6. 21 Mar, 2009 1 commit
    • Tom Lane's avatar
      Optimize multi-batch hash joins when the outer relation has a nonuniform · 596efd27
      Tom Lane authored
      distribution, by creating a special fast path for the (first few) most common
      values of the outer relation.  Tuples having hashvalues matching the MCVs
      are effectively forced to be in the first batch, so that we never write
      them out to the batch temp files.
      
      Bryce Cutt and Ramon Lawrence, with some editorialization by me.
      596efd27
  7. 20 Mar, 2009 1 commit
  8. 18 Mar, 2009 6 commits
  9. 17 Mar, 2009 3 commits