Re: max_fsm_pages - Mailing list pgsql-general

From Tom Lane
Subject Re: max_fsm_pages
Date
Msg-id 9259.1088741286@sss.pgh.pa.us
Whole thread Raw
In response to Re: max_fsm_pages  (<wespvp@syntegra.com>)
List pgsql-general
<wespvp@syntegra.com> writes:
> If I bump up max_fsm_pages to 1,000,000 and run VACUUM ANALYZE, then would
> all 900,000 rows then be available for reused?

VACUUM will fill whatever FSM space is available.  You do have to
restart the postmaster to get the increased FSM size to be allocated,
but you don't have to do any magic pushups beyond that.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: row level grants
Next
From: "Lee Harr"
Date:
Subject: get first / last date of given week