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 |
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 |