Vacuum suggesting doubling of max_fsm_pages - Mailing list pgsql-general

From Kenneth Downs
Subject Vacuum suggesting doubling of max_fsm_pages
Date
Msg-id 4450DDEF.9010306@secdat.com
Whole thread Raw
Responses Re: Vacuum suggesting doubling of max_fsm_pages  (Vivek Khera <vivek@khera.org>)
List pgsql-general
Hi folks I'm hoping somebody can demystify something for me.

I've got a test database that is going live.

During development I have not vacuum'd much, so to get started I did
"Vacuum verbose analyze".

At the end of the process it told me that vacuum needed max_fsm_pages to
be set at about 212000 (appx) to track all free pages.

I then ran it again (w/o yet changing max_fsm_pages) and it came back
asking for a number in the range of 490000.

So I set the value to 500000, restarted the server, and ran vacuum
again.  This time it suggested a value of 980000.

It appears to me the requests are doubling in size, so before increasing
it again I thought I would ask here.

Attachment

pgsql-general by date:

Previous
From: "codeWarrior"
Date:
Subject: Re: PostgreSQL 8.1 + PHP5.1.x/4.4.2 + Apache 2.0.55/1.3.34 PROBLEM!! PLEASE HELP
Next
From: "codeWarrior"
Date:
Subject: Re: selecting column comment