Skip to content
Snippets Groups Projects
  1. Aug 08, 2006
    • Bruce Momjian's avatar
      Add package item: · 46d759cf
      Bruce Momjian authored
      < 		o Add Oracle-style packages
      > 		o Add Oracle-style packages  (Pavel)
      > * Pavel is Pavel Stehule <pavel.stehule@hotmail.com>
      46d759cf
    • Bruce Momjian's avatar
      Done: · 2392cdb7
      Bruce Momjian authored
      < 	  o Automatically force archiving of partially-filled WAL files when
      > 	  o -Automatically force archiving of partially-filled WAL files when
      <
      < 	    Doing this will allow administrators to know more easily when
      < 	    the archive contains all the files needed for point-in-time
      < 	    recovery.
      < 	    http://archives.postgresql.org/pgsql-patches/2005-04/msg00121.php
      <
      < 	  o Add reporting of the current WAL file and offset, perhaps as
      > 	  o -Add reporting of the current WAL file and offset, perhaps as
      <
      < 	    The offset allows parts of a WAL file to be archived using
      < 	    an external program.
      <
      2392cdb7
    • Bruce Momjian's avatar
      Done: · d42cb5d8
      Bruce Momjian authored
      < * Allow protocol-level BIND parameter values to be logged
      <
      <   http://archives.postgresql.org/pgsql-hackers/2006-02/msg00165.php
      > * -Allow protocol-level BIND parameter values to be logged, if text mode
      d42cb5d8
    • Bruce Momjian's avatar
      For protocol-level prepare/bind/execute: · 3716f90c
      Bruce Momjian authored
      	o  print user name for all
      	o  print portal name if defined for all
      	o  print query for all
      	o  reduce log_statement header to single keyword
      	o  print bind parameters as DETAIL if text mode
      3716f90c
  2. Aug 06, 2006
    • Tom Lane's avatar
      Add support for forcing a switch to a new xlog file; cause such a switch · 704ddaaa
      Tom Lane authored
      to happen automatically during pg_stop_backup().  Add some functions for
      interrogating the current xlog insertion point and for easily extracting
      WAL filenames from the hex WAL locations displayed by pg_stop_backup
      and friends.  Simon Riggs with some editorialization by Tom Lane.
      704ddaaa
  3. Aug 04, 2006
  4. Aug 03, 2006
    • Tom Lane's avatar
      Cause ALTER TABLE to perform ALTER COLUMN DROP DEFAULT operations during · 7946f772
      Tom Lane authored
      the DROP pass rather than the ADD_CONSTR pass.  On examining the code I
      think this was just an oversight rather than intentional, and it seems
      to satisfy the principle of least surprise better than the alternative
      solution that was discussed.  Add an example to the ref page showing how
      to do ALTER TYPE and update the default in one command.  Per gripe from
      Markus Bertheau that that wasn't possible.
      7946f772
  5. Aug 02, 2006
  6. Aug 01, 2006
  7. Jul 31, 2006
    • Tom Lane's avatar
      Change the relation_open protocol so that we obtain lock on a relation · 09d3670d
      Tom Lane authored
      (table or index) before trying to open its relcache entry.  This fixes
      race conditions in which someone else commits a change to the relation's
      catalog entries while we are in process of doing relcache load.  Problems
      of that ilk have been reported sporadically for years, but it was not
      really practical to fix until recently --- for instance, the recent
      addition of WAL-log support for in-place updates helped.
      
      Along the way, remove pg_am.amconcurrent: all AMs are now expected to support
      concurrent update.
      09d3670d
    • Tom Lane's avatar
      Change the bootstrap sequence so that toast tables for system catalogs are · 6e38e34d
      Tom Lane authored
      created in the bootstrap phase proper, rather than added after-the-fact
      by initdb.  This is cleaner than before because it allows us to retire the
      undocumented ALTER TABLE ... CREATE TOAST TABLE command, but the real reason
      I'm doing it is so that toast tables of shared catalogs will now have
      predetermined OIDs.  This will allow a reasonably clean solution to the
      problem of locking tables before we load their relcache entries, to appear
      in a forthcoming patch.
      6e38e34d
    • Alvaro Herrera's avatar
  8. Jul 30, 2006
    • Bruce Momjian's avatar
      Add: · d6603791
      Bruce Momjian authored
      > * Consider detoasting keys before sorting
      d6603791
  9. Jul 29, 2006
  10. Jul 28, 2006
  11. Jul 27, 2006
  12. Jul 26, 2006
    • Bruce Momjian's avatar
      Reorder items: · 5ffa0bb4
      Bruce Momjian authored
      < 	  o Allow point-in-time recovery to archive partially filled
      < 	    write-ahead logs? [pitr]
      > 	  o Add command to archive partially filled write-ahead logs? [pitr]
      < 	    of a disk failure. This could be triggered by a user command or
      < 	    a timer.
      > 	    of a disk failure.
      < 	    recovery.  A function call to do this would also be useful.
      > 	    recovery.
      > 	  o Add reporting of the current WAL file and offset, perhaps as
      > 	    part of partial log file archiving
      >
      > 	    The offset allows parts of a WAL file to be archived using
      > 	    an external program.
      >
      < 	  o Add reporting of the current WAL file and offset, perhaps as
      < 	    part of partial log file archiving
      <
      < 	    The offset allows parts of a WAL file to be archived using
      < 	    an external program.
      5ffa0bb4
    • Peter Eisentraut's avatar
      Convert effective_cache_size to an integer, for better integration with · 79bc99a4
      Peter Eisentraut authored
      upcoming units feature.
      79bc99a4
    • Bruce Momjian's avatar
      Done: · 88b39634
      Bruce Momjian authored
      > * -Change LIMIT/OFFSET and FETCH/MOVE to use int8
      88b39634
  13. Jul 25, 2006
    • Bruce Momjian's avatar
      Add reason for WAL offset reporting: · edd49fcf
      Bruce Momjian authored
      >
      > 	    The offset allows parts of a WAL file to be archived using
      > 	    an external program.
      edd49fcf
    • Bruce Momjian's avatar
      Add offset mention: · 8633a9cd
      Bruce Momjian authored
      < 	  o Add reporting of the current WAL file, perhaps as part of
      < 	    partial log file archiving
      > 	  o Add reporting of the current WAL file and offset, perhaps as
      > 	    part of partial log file archiving
      8633a9cd
    • Bruce Momjian's avatar
      Update PITR: · cb6f5f15
      Bruce Momjian authored
      < 	    write-ahead logs [pitr]
      > 	    write-ahead logs? [pitr]
      < 	    recovery.
      > 	    recovery.  A function call to do this would also be useful.
      cb6f5f15
Loading