1. 13 3月, 2001 2 次提交
    • T
      XLOG (and related) changes: · 4d14fe00
      Tom Lane 提交于
      * Store two past checkpoint locations, not just one, in pg_control.
        On startup, we fall back to the older checkpoint if the newer one
        is unreadable.  Also, a physical copy of the newest checkpoint record
        is kept in pg_control for possible use in disaster recovery (ie,
        complete loss of pg_xlog).  Also add a version number for pg_control
        itself.  Remove archdir from pg_control; it ought to be a GUC
        parameter, not a special case (not that it's implemented yet anyway).
      
      * Suppress successive checkpoint records when nothing has been entered
        in the WAL log since the last one.  This is not so much to avoid I/O
        as to make it actually useful to keep track of the last two
        checkpoints.  If the things are right next to each other then there's
        not a lot of redundancy gained...
      
      * Change CRC scheme to a true 64-bit CRC, not a pair of 32-bit CRCs
        on alternate bytes.  Polynomial borrowed from ECMA DLT1 standard.
      
      * Fix XLOG record length handling so that it will work at BLCKSZ = 32k.
      
      * Change XID allocation to work more like OID allocation.  (This is of
        dubious necessity, but I think it's a good idea anyway.)
      
      * Fix a number of minor bugs, such as off-by-one logic for XLOG file
        wraparound at the 4 gig mark.
      
      * Add documentation and clean up some coding infelicities; move file
        format declarations out to include files where planned contrib
        utilities can get at them.
      
      * Checkpoint will now occur every CHECKPOINT_SEGMENTS log segments or
        every CHECKPOINT_TIMEOUT seconds, whichever comes first.  It is also
        possible to force a checkpoint by sending SIGUSR1 to the postmaster
        (undocumented feature...)
      
      * Defend against kill -9 postmaster by storing shmem block's key and ID
        in postmaster.pid lockfile, and checking at startup to ensure that no
        processes are still connected to old shmem block (if it still exists).
      
      * Switch backends to accept SIGQUIT rather than SIGUSR1 for emergency
        stop, for symmetry with postmaster and xlog utilities.  Clean up signal
        handling in bootstrap.c so that xlog utilities launched by postmaster
        will react to signals better.
      
      * Standalone bootstrap now grabs lockfile in target directory, as added
        insurance against running it in parallel with live postmaster.
      4d14fe00
    • T
      Avoid O(N^2) behavior in deferredTriggerAddEvent() for large numbers of · b246510c
      Tom Lane 提交于
      tuples inserted/deleted/updated in a single transaction.  On my machine,
      this reduced the time to delete 80000 tuples in a foreign-key-referencing
      table from ~15min to ~8sec.
      b246510c
  2. 12 3月, 2001 1 次提交
  3. 11 3月, 2001 9 次提交
  4. 10 3月, 2001 6 次提交
  5. 09 3月, 2001 4 次提交
  6. 08 3月, 2001 5 次提交
    • T
      A subplan invoked within an aggregate function's argument should · d73e9df0
      Tom Lane 提交于
      be allowed to receive ungrouped variables of the current query level.
      Curious that no one reported this bug before...
      d73e9df0
    • T
      Modify wchar conversion routines to not fetch the next byte past the end · 572fda27
      Tom Lane 提交于
      of a counted input string.  Marinos Yannikos' recent crash report turns
      out to be due to applying pg_ascii2wchar_with_len to a TEXT object that
      is smack up against the end of memory.  This is the second just-barely-
      reproducible bug report I have seen that traces to some bit of code
      fetching one more byte than it is allowed to.  Let's be more careful
      out there, boys and girls.
      While at it, I changed the code to not risk a similar crash when there
      is a truncated multibyte character at the end of an input string.  The
      output in this case might not be the most reasonable output possible;
      if anyone wants to improve it further, step right up...
      572fda27
    • T
      Repair a number of places that didn't bother to check whether PageAddItem · b109b03f
      Tom Lane 提交于
      succeeds or not.  Revise rtree page split algorithm to take care about
      making a feasible split --- ie, will the incoming tuple actually fit?
      Failure to make a feasible split, combined with failure to notice the
      failure, account for Jim Stone's recent bug report.  I suspect that
      hash and gist indices may have the same type of bug, but at least now
      we'll get error messages rather than silent failures if so.  Also clean
      up rtree code to use Datum rather than char* where appropriate.
      b109b03f
    • B
      > Applied. Thanks. · 296c806d
      Bruce Momjian 提交于
      One more :)) It's for improper function argumets for
      PLTCL_UNKNOWN_SUPPORT code
      
      I'm not an autoconf expert, but is it possible to enable unknown
      support in pltcl with configure option ?
      This support is really handy for real life usage of pl/tcl.
      
      seva@sevasoft.kiev.ua
      296c806d
    • B
      pltcl_loadmod has problems with big (>4k) modules because of missing incr · 3dc1b2b7
      Bruce Momjian 提交于
      in splitting code:
      
      seva@sevasoft.kiev.ua
      3dc1b2b7
  7. 07 3月, 2001 7 次提交
  8. 06 3月, 2001 6 次提交