1. 14 Sep, 2006 1 commit
  2. 02 Sep, 2006 2 commits
  3. 29 Aug, 2006 1 commit
  4. 28 Aug, 2006 1 commit
  5. 17 Aug, 2006 1 commit
    • Tom Lane's avatar
      Implement archive_timeout feature to force xlog file switches to occur no more · e8ea9e95
      Tom Lane authored
      than N seconds apart.  This allows a simple, if not very high performance,
      means of guaranteeing that a PITR archive is no more than N seconds behind
      real time.  Also make pg_current_xlog_location return the WAL Write pointer,
      add pg_current_xlog_insert_location to return the Insert pointer, and fix
      pg_xlogfile_name_offset to return its results as a two-element record instead
      of a smashed-together string, as per recent discussion.
      
      Simon Riggs
      e8ea9e95
  6. 15 Aug, 2006 1 commit
    • Tom Lane's avatar
      Add server support for "plugin" libraries that can be used for add-on tasks · abc3120e
      Tom Lane authored
      such as debugging and performance measurement.  This consists of two features:
      a table of "rendezvous variables" that allows separately-loaded shared
      libraries to communicate, and a new GUC setting "local_preload_libraries"
      that allows libraries to be loaded into specific sessions without explicit
      cooperation from the client application.  To make local_preload_libraries
      as flexible as possible, we do not restrict its use to superusers; instead,
      it is restricted to load only libraries stored in $libdir/plugins/.  The
      existing LOAD command has also been modified to allow non-superusers to
      LOAD libraries stored in this directory.
      
      This patch also renames the existing GUC variable preload_libraries to
      shared_preload_libraries (after a suggestion by Simon Riggs) and does some
      code refactoring in dfmgr.c to improve clarity.
      
      Korry Douglas, with a little help from Tom Lane.
      abc3120e
  7. 02 Aug, 2006 1 commit
  8. 25 Jul, 2006 1 commit
    • Tom Lane's avatar
      Remove hard-wired lists of timezone abbreviations in favor of providing · d8b5c95c
      Tom Lane authored
      configuration files that can be altered by a DBA.  The australian_timezones
      GUC setting disappears, replaced by a timezone_abbreviations setting (set this
      to 'Australia' to get the effect of australian_timezones).  The list of zone
      names defined by default has undergone a bit of cleanup, too.  Documentation
      still needs some work --- in particular, should we fix Table B-4, or just get
      rid of it?  Joachim Wieland, with some editorializing by moi.
      d8b5c95c
  9. 24 Jul, 2006 1 commit
  10. 27 Jun, 2006 2 commits
  11. 19 Jun, 2006 1 commit
  12. 05 Jun, 2006 2 commits
    • Tom Lane's avatar
      Increase the default value of cpu_index_tuple_cost from 0.001 to 0.005. · e4de635a
      Tom Lane authored
      This shouldn't affect simple indexscans much, while for bitmap scans that
      are touching a lot of index rows, this seems to bring the estimates more
      in line with reality.  Per recent discussion.
      e4de635a
    • Tom Lane's avatar
      Add a GUC parameter seq_page_cost, and use that everywhere we formerly · eed6c9ed
      Tom Lane authored
      assumed that a sequential page fetch has cost 1.0.  This patch doesn't
      in itself change the system's behavior at all, but it opens the door to
      people adopting other units of measurement for EXPLAIN costs.  Also, if
      we ever decide it's worth inventing per-tablespace access cost settings,
      this change provides a workable intellectual framework for that.
      eed6c9ed
  13. 21 May, 2006 1 commit
    • Tom Lane's avatar
      Add a new GUC parameter backslash_quote, which determines whether the SQL · b3eb4ea5
      Tom Lane authored
      parser will allow "\'" to be used to represent a literal quote mark.  The
      "\'" representation has been deprecated for some time in favor of the
      SQL-standard representation "''" (two single quote marks), but it has been
      used often enough that just disallowing it immediately won't do.  Hence
      backslash_quote allows the settings "on", "off", and "safe_encoding",
      the last meaning to allow "\'" only if client_encoding is a valid server
      encoding.  That is now the default, and the reason is that in encodings
      such as SJIS that allow 0x5c (ASCII backslash) to be the last byte of a
      multibyte character, accepting "\'" allows SQL-injection attacks as per
      CVE-2006-2314 (further details will be published after release).  The
      "on" setting is available for backward compatibility, but it must not be
      used with clients that are exposed to untrusted input.
      
      Thanks to Akio Ishida and Yasuo Ohgaki for identifying this security issue.
      b3eb4ea5
  14. 11 May, 2006 1 commit
  15. 06 Mar, 2006 2 commits
  16. 23 Dec, 2005 2 commits
  17. 17 Nov, 2005 1 commit
    • Tom Lane's avatar
      Make SQL arrays support null elements. This commit fixes the core array · cecb6075
      Tom Lane authored
      functionality, but I still need to make another pass looking at places
      that incidentally use arrays (such as ACL manipulation) to make sure they
      are null-safe.  Contrib needs work too.
      I have not changed the behaviors that are still under discussion about
      array comparison and what to do with lower bounds.
      cecb6075
  18. 10 Nov, 2005 1 commit
    • Andrew Dunstan's avatar
      · f9db22e8
      Andrew Dunstan authored
      add missing quote mark to ident_file sample line - per Hiroshi Saito
      f9db22e8
  19. 09 Nov, 2005 1 commit
  20. 08 Oct, 2005 1 commit
  21. 20 Sep, 2005 1 commit
  22. 12 Sep, 2005 1 commit
    • Tom Lane's avatar
      Tweak TCP-keepalive code so that an invalid setting doesn't cause us · cc3bda37
      Tom Lane authored
      to drop connections unceremoniously.  Also some other marginal cleanups:
      don't query getsockopt() repeatedly if it fails, and avoid having the
      apparent definition of struct Port depend on which system headers you
      might have included or not.  Oliver Jowett and Tom Lane.
      cc3bda37
  23. 02 Sep, 2005 2 commits
  24. 30 Aug, 2005 1 commit
  25. 29 Aug, 2005 1 commit
    • Tom Lane's avatar
      Reduce default value of max_prepared_transactions from 50 to 5. This · 037709e0
      Tom Lane authored
      saves nearly 700kB in the default shared memory segment size, which seems
      worthwhile, and it is a feature that many users won't use anyway.  Per
      Heikki's argument, there is no point in a compromise value --- those who
      are using 2PC at all will probably want it at least equal to max_connections.
      But we can't set it to zero by default without breaking the prepared_xacts
      regression test.
      037709e0
  26. 22 Aug, 2005 1 commit
  27. 21 Aug, 2005 1 commit
  28. 20 Aug, 2005 1 commit
    • Tom Lane's avatar
      Convert the arithmetic for shared memory size calculation from 'int' · 0007490e
      Tom Lane authored
      to 'Size' (that is, size_t), and install overflow detection checks in it.
      This allows us to remove the former arbitrary restrictions on NBuffers
      etc.  It won't make any difference in a 32-bit machine, but in a 64-bit
      machine you could theoretically have terabytes of shared buffers.
      (How efficiently we could manage 'em remains to be seen.)  Similarly,
      num_temp_buffers, work_mem, and maintenance_work_mem can be set above
      2Gb on a 64-bit machine.  Original patch from Koichi Suzuki, additional
      work by moi.
      0007490e
  29. 19 Aug, 2005 1 commit
  30. 11 Aug, 2005 1 commit
    • Tom Lane's avatar
      Autovacuum loose end mop-up. Provide autovacuum-specific vacuum cost · d90c5311
      Tom Lane authored
      delay and limit, both as global GUCs and as table-specific entries in
      pg_autovacuum.  stats_reset_on_server_start is now OFF by default,
      but a reset is forced if we did WAL replay.  XID-wrap vacuums do not
      ANALYZE, but do FREEZE if it's a template database.  Alvaro Herrera
      d90c5311
  31. 09 Aug, 2005 1 commit
  32. 30 Jul, 2005 1 commit
  33. 23 Jul, 2005 1 commit
  34. 14 Jul, 2005 1 commit