Search Postgresql Archives

Vacuum suggesting doubling of max_fsm_pages

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.
begin:vcard
fn:Kenneth  Downs
n:Downs;Kenneth 
email;internet:ken@xxxxxxxxxx
tel;work:631-689-7200
tel;fax:631-689-0527
tel;cell:631-379-0010
x-mozilla-html:FALSE
version:2.1
end:vcard


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux