Vacuum suggesting doubling of max_fsm_pages

From: Kenneth Downs <ken(at)secdat(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Vacuum suggesting doubling of max_fsm_pages
Date: 2006-04-27 15:06:23
Message-ID: 4450DDEF.9010306@secdat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
ken.vcf text/x-vcard 186 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Aly Dharshi 2006-04-27 15:12:53 Re: Installing PostgreSQL on Win 2003 R2 64-bit
Previous Message codeWarrior 2006-04-27 15:05:04 Re: PostgreSQL 8.1 + PHP5.1.x/4.4.2 + Apache 2.0.55/1.3.34 PROBLEM!! PLEASE HELP