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, a
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 t
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 wil
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
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 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 1
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 har