Calculation for Max_FSM_pages : Any rules of thumb?

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Calculation for Max_FSM_pages : Any rules of thumb?
Date: 2007-11-02 00:51:24
Message-ID: 1193964684.9625.8.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I just ran a vacuum verbose on the entire DB and this came out.

number of page slots needed (274144) exceeds max_fsm_pages (153600)

Hence, I've changed the max to 400,000 (pulled it straight out of the
air). How does one calculate what's the number needed anyway?

Another question is, based on what I've read in the archives (in my
laptop.. No-Inet conn @ work) Since I've overran my max_FSM, I'm
basically screwed and will have to do a vacuum verbose FULL on the
entire DB. Crap..

(I was playing with pgfouine and then I found the above piece of advice)

I'm planning to run vacuum verbose full tonight/over the weekend. (is
this sane?) Thanks for the advice..

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-11-02 00:56:34 Re: Calculation for Max_FSM_pages : Any rules of thumb?
Previous Message Tom Lane 2007-11-01 23:04:20 Re: posgresql-8.2 startup problem