Hi Frank,

Thanks! for the quick reply, here are my current default fsm setting .
max_fsm_pages = 20000 and max_fsm_relations = 1000
What are the appropriates settings for these parameters ? are there any guidlines ? postgres docs doesnt give much information on setting these values.


Frank Wiles wrote:

On Thu, 02 Dec 2004 14:11:46 -0500
Pallav Kalva <[EMAIL PROTECTED]> wrote:

Hi ,

I have a table in my production database which has 500k rows and from the pg_class it shows the number of "relpages" of
around 750K for this table, the same table copied to a test database shows "relpages" as 35k. I run vacuumdb on the whole
database (not on the table individually but the whole database) daily.

I think because of this most of queries are slowing down which used to

run much faster before.
Is there any way to fix this problem ?

Try a VACUUM FULL, this will clean up unused space. You might also
want to adjust your free space map so that you don't have to do FULL
vacuums as often ( or at all ). It is controlled by max_fsm_pages
and max_fsm_relations.

  Frank Wiles <[EMAIL PROTECTED]>

---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Reply via email to