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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Tom Lane Sent: Saturday, November 05, 2005 10:23 PM To: Carlos Oliva Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Setting max_fsm_pages "Carlos Oliva" <carlos@xxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
