1. 01 Dec, 2003 1 commit
  2. 19 Nov, 2003 1 commit
    • Jan Wieck's avatar
      Background writer process · cfeca621
      Jan Wieck authored
      This first part of the background writer does no syncing at all.
      It's only purpose is to keep the LRU heads clean so that regular
      backends seldom to never have to call write().
      
      Jan
      cfeca621
  3. 16 Nov, 2003 1 commit
  4. 13 Nov, 2003 3 commits
  5. 08 Oct, 2003 1 commit
  6. 03 Oct, 2003 1 commit
  7. 07 Sep, 2003 1 commit
    • Tom Lane's avatar
      Remove geqo_random_seed parameter. Having geqo reset the global random() · 48beecda
      Tom Lane authored
      sequence every time it's called is bogus --- it interferes with user
      control over the seed, and actually decreases randomness overall
      (because a seed based on time(NULL) is pretty predictable).  If you really
      want a reproducible result from geqo, do 'set seed = 0' before planning
      a query.
      48beecda
  8. 26 Aug, 2003 1 commit
  9. 17 Aug, 2003 1 commit
    • Bruce Momjian's avatar
      (I always forget what the magic numbers 0 through 2 means for the · d4be99f6
      Bruce Momjian authored
      "syslog" option.)
      
      By the way: The "virtual_host" parameter is a bad name for that
      particular option, I think. "Virtual host" signals that PostgreSQL will
      behave differently according to which IP address it's contacted (like
      Apache's virtual host support which makes the web-server serve different
      sites according to different criteria). A better word for the options
      would be "tcpip_listen_addr" or something like that.
      
      Troels Arvin
      d4be99f6
  10. 29 Jul, 2003 1 commit
    • Tom Lane's avatar
      Apply (a somewhat revised version of) Greg Mullane's patch to eliminate · 9c2a7c22
      Tom Lane authored
      heuristic determination of day vs month in date/time input.  Add the
      ability to specify that input is interpreted as yy-mm-dd order (which
      formerly worked, but only for yy greater than 31).  DateStyle's input
      component now has the preferred spellings DMY, MDY, or YMD; the older
      keywords European and US are now aliases for the first two of these.
      Per recent discussions on pgsql-general.
      9c2a7c22
  11. 22 Jul, 2003 1 commit
  12. 18 Jul, 2003 1 commit
  13. 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
  14. 04 Jul, 2003 1 commit
  15. 30 Jun, 2003 1 commit
  16. 11 Jun, 2003 3 commits
  17. 14 May, 2003 1 commit
  18. 19 Apr, 2003 1 commit
  19. 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
  20. 30 Mar, 2003 1 commit
  21. 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
  22. 24 Mar, 2003 1 commit
  23. 20 Mar, 2003 1 commit
    • 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
  24. 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
  25. 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
  26. 28 Jan, 2003 2 commits
  27. 27 Jan, 2003 1 commit
  28. 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
  29. 15 Jan, 2003 2 commits
  30. 11 Jan, 2003 1 commit
  31. 09 Jan, 2003 1 commit
  32. 27 Dec, 2002 1 commit
  33. 21 Nov, 2002 1 commit
  34. 15 Nov, 2002 1 commit