Thank you for your response Tom.
Should I set the max_fsm_pages to the "total pages needed" obtained from a
full vacuum or from a analize vacuum? When I run a vacuum analyze (vacuumdb
-z -v), I get a smaller number of pages needed than when I run a full vacuum
with analyze (vacuumdb -f -z -v)
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Saturday, November 05, 2005 10:23 PM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Setting max_fsm_pages
"Carlos Oliva" <carlos@pbsinet.com> writes:
> Should I set the max_fsm_pages to the value reported (vacuum verbose) as
> pages stored or the value reported as total pages needed?
Total pages needed ... if not more.
regards, tom lane
---------------------------(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
