On Thu, 2007-12-06 at 21:40 -0500, Kris Jurka wrote:
Yes, the commented out values are the defaults, but after initdb
max_fsm_pages is not commented out, which is why I'm suggesting you
or
some other admin modified your file. Try this test:
Kris-
You're completely right, of course, and
Kris-
Thanks for digging into the code for that. Unfortunately, I'm now more
confused.
the actual default at initdb time can be set as high as nbuffers *
50,
where the max shared_buffers is 4096. So the default max_fsm_pages
for a
beefier machine will be 204800 which is what you will
On Thu, 6 Dec 2007, Reece Hart wrote:
This seems to directly say that the commented out settings are the
default values, and furthermore that one must restart to get the
indicated default back. Based on your evidence, it seems that the
postgresql.conf comment for max_fsm_pages needs revising
The following bug has been logged online:
Bug reference: 3801
Logged by: Reece Hart
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: Linux (SLES 10)
Description:max_fsm_pages postgresql.conf default != guc.c default
Details:
The guc.c
On Thu, 6 Dec 2007, Reece Hart wrote:
Bug reference: 3801
PostgreSQL version: 8.2.5
Description:max_fsm_pages postgresql.conf default != guc.c default
Details:
The guc.c hardwired default for max_fsm_pages is 2. In postgresql.conf
(and .sample), the default is claimed to be
On Wed, 2007-12-05 at 23:20 -0500, Kris Jurka wrote:
You need to consider the units. guc.c is in number of pages, while
postgresql.conf is in kB. Since the page size is 8192, these are
equivalent.
I did consider that, but I'm not certain that it's that simple. Here's
why:
First, the
On Wed, 5 Dec 2007, Reece Hart wrote:
On Wed, 2007-12-05 at 23:20 -0500, Kris Jurka wrote:
You need to consider the units. guc.c is in number of pages, while
postgresql.conf is in kB. Since the page size is 8192, these are
equivalent.
I did consider that, but I'm not certain that it's