Re: Setting max_fsm_pages

From: "Carlos Oliva" <carlos(at)pbsinet(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Setting max_fsm_pages
Date: 2005-11-07 01:05:29
Message-ID: 200511070108.UAA08928@pbsi.pbsinet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Saturday, November 05, 2005 10:23 PM
To: Carlos Oliva
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Setting max_fsm_pages

"Carlos Oliva" <carlos(at)pbsinet(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Assad Jarrahian 2005-11-07 01:06:11 Connect to a database in a .sql file
Previous Message Chris 2005-11-06 22:54:15 Re: How to create a virtual column