1. 14 Jul, 2003 1 commit
    • Tom Lane's avatar
      The default values for shared_buffers and max_connections are now 1000 · de98a7e2
      Tom Lane authored
      and 100 respectively, if the platform will allow it.  initdb selects
      values that are not too large to allow the postmaster to start, and
      places these values in the installed postgresql.conf file.  This allows
      us to continue to start up out-of-the-box on platforms with small SHMMAX,
      while having somewhat-realistic default settings on platforms with
      reasonable SHMMAX.  Per recent pghackers discussion.
      de98a7e2
  2. 09 Jul, 2003 2 commits
  3. 04 Jul, 2003 1 commit
  4. 30 Jun, 2003 1 commit
  5. 27 Jun, 2003 1 commit
  6. 25 Jun, 2003 1 commit
  7. 12 Jun, 2003 2 commits
  8. 11 Jun, 2003 2 commits
  9. 27 May, 2003 1 commit
  10. 23 May, 2003 1 commit
  11. 15 May, 2003 1 commit
  12. 14 May, 2003 1 commit
  13. 04 May, 2003 1 commit
  14. 04 Apr, 2003 1 commit
  15. 03 Apr, 2003 1 commit
    • Tom Lane's avatar
      Remove zero_damaged_pages from postgresql.conf.sample; the only way to · a385186f
      Tom Lane authored
      find out about it is to read the documentation that tells you how
      dangerous it is.  Add default_transaction_read_only to documentation;
      seems to have been overlooked in patch that added read-only transactions.
      Clean up check_guc comparison script, which has been suffering bit rot.
      a385186f
  16. 28 Mar, 2003 1 commit
    • Tom Lane's avatar
      Add code to apply some simple sanity checks to the header fields of a · fd422628
      Tom Lane authored
      page when it's read in, per pghackers discussion around 17-Feb.  Add a
      GUC variable zero_damaged_pages that causes the response to be a WARNING
      followed by zeroing the page, rather than the normal ERROR; this is per
      Hiroshi's suggestion that there needs to be a way to get at the data
      in the rest of the table.
      fd422628
  17. 25 Mar, 2003 1 commit
  18. 24 Mar, 2003 1 commit
  19. 20 Mar, 2003 2 commits
    • Bruce Momjian's avatar
      > I can see a couple possible downsides: (a) the library might have some · 15ce2d2e
      Bruce Momjian authored
      > weird behavior across fork boundaries; (b) the additional memory space
      > that has to be duplicated into child processes will cost something per
      > child launch, even if the child never uses it.  But these are only
      > arguments that it might not *always* be a prudent thing to do, not that
      > we shouldn't give the DBA the tool to do it if he wants.  So fire away.
      
      Here is a patch for the above, including a documentation update. It
      creates a new GUC variable "preload_libraries", that accepts a list in
      the form:
      
         preload_libraries = '$libdir/mylib1:initfunc,$libdir/mylib2'
      
      If ":initfunc" is omitted or not found, no initialization function is
      executed, but the library is still preloaded. If "$libdir/mylib" isn't
      found, the postmaster refuses to start.
      
      In my testing with PL/R, it reduces the first call to a PL/R function
      (after connecting) from almost 2 seconds, down to about 8 ms.
      
      Joe Conway
      15ce2d2e
    • Bruce Momjian's avatar
      Add start time to pg_stat_activity · a1833100
      Bruce Momjian authored
      Neil Conway
      a1833100
  20. 04 Mar, 2003 1 commit
    • Tom Lane's avatar
      Reimplement free-space-map management as per recent discussions. · 391eb5e5
      Tom Lane authored
      Adjustable threshold is gone in favor of keeping track of total requested
      page storage and doling out proportional fractions to each relation
      (with a minimum amount per relation, and some quantization of the results
      to avoid thrashing with small changes in page counts).  Provide special-
      case code for indexes so as not to waste space storing useless page
      free space counts.  Restructure internal data storage to be a flat array
      instead of list-of-chunks; this may cost a little more work in data
      copying when reorganizing, but allows binary search to be used during
      lookup_fsm_page_entry().
      391eb5e5
  21. 19 Feb, 2003 1 commit
    • Bruce Momjian's avatar
      This patch makes the following changes to the documentation: · cde8bbc4
      Bruce Momjian authored
      - more work from the SGML police
      
      - some grammar improvements: rewriting a paragraph or two, replacing
      contractions where (IMHO) appropriate
      
      - fix missing utility commands in lock mode docs
      
      - improve CLUSTER, REINDEX, SET SESSION AUTHORIZATION ref pages
      
      Neil Conway
      cde8bbc4
  22. 06 Feb, 2003 1 commit
    • Tom Lane's avatar
      Create a GUC variable REGEX_FLAVOR to control the type of regular · 77ede890
      Tom Lane authored
      expression accepted by the regex operators, per discussion yesterday.
      
      Along the way, reduce deadlock_timeout from PGC_POSTMASTER to PGC_SIGHUP
      category.  It is probably best to insist that all backends share the same
      setting, but that doesn't mean it has to be frozen at startup.
      77ede890
  23. 25 Jan, 2003 1 commit
    • Tom Lane's avatar
      Allow the planner to collapse explicit inner JOINs together, rather than · 9f5f2124
      Tom Lane authored
      necessarily following the JOIN syntax to develop the query plan.  The old
      behavior is still available by setting GUC variable JOIN_COLLAPSE_LIMIT
      to 1.  Also create a GUC variable FROM_COLLAPSE_LIMIT to control the
      similar decision about when to collapse sub-SELECT lists into their parent
      lists.  (This behavior existed already, but the limit was always
      GEQO_THRESHOLD/2; now it's separately adjustable.)
      9f5f2124
  24. 11 Jan, 2003 1 commit
  25. 27 Dec, 2002 1 commit
  26. 10 Dec, 2002 1 commit
  27. 09 Dec, 2002 1 commit
  28. 06 Dec, 2002 2 commits
  29. 04 Dec, 2002 1 commit
  30. 21 Nov, 2002 3 commits
  31. 15 Nov, 2002 3 commits