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:[EMAIL PROTECTED]
tel;work:631-689-7200
tel;fax:631-689-0527
tel;cell:631-379-0010
x-mozilla-html:FALSE
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
