Re: BUG #3801: max_fsm_pages postgresql.conf default != guc.c default - Mailing list pgsql-bugs

From Kris Jurka
Subject Re: BUG #3801: max_fsm_pages postgresql.conf default != guc.c default
Date
Msg-id Pine.BSO.4.64.0712052318361.26346@leary.csoft.net
Whole thread Raw
In response to BUG #3801: max_fsm_pages postgresql.conf default != guc.c default  ("Reece Hart" <reece@harts.net>)
Responses Re: BUG #3801: max_fsm_pages postgresql.conf default != guc.c default  (Reece Hart <reece@harts.net>)
List pgsql-bugs
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 20000. In postgresql.conf
> (and .sample), the default is claimed to be 1638400. I don't know which is
> correct.
>

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.

Kris Jurka

pgsql-bugs by date:

Previous
From: Kris Jurka
Date:
Subject: Re: BUG #3800: Java/Postgres PreparedStatement returns stale data
Next
From: Reece Hart
Date:
Subject: Re: BUG #3801: max_fsm_pages postgresql.conf default != guc.c default