Re: max_fsm_pages

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: wespvp(at)syntegra(dot)com
Cc: Scott Marlowe <smarlowe(at)qwest(dot)net>, Postgres List <pgsql-general(at)postgresql(dot)org>
Subject: Re: max_fsm_pages
Date: 2004-07-02 04:08:06
Message-ID: 9259.1088741286@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<wespvp(at)syntegra(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mike g 2004-07-02 04:22:38 Re: Extract data from MySQL database using PostgreSQL
Previous Message Tom Lane 2004-07-02 03:59:34 Re: row level grants