postgresql.conf setting for max_fsm_pages

From: ahchuan <chiochuan(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: postgresql.conf setting for max_fsm_pages
Date: 2012-04-04 09:22:01
Message-ID: 6838c23d-4980-458b-8428-8c5590580011@jx17g2000pbb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi All,

I am new in using postgresSQL, I now support a system that been
running on postgressql. Recently I found that the database are
consuming the diskspace rapidly, it starting from 9GB and it now grow
until 40GB within 4-5 month.

I try to do a full vacuum to the database but then i get this error

NOTICE: number of page slots needed (1277312) exceeds max_fsm_pages
(819200)
HINT: Consider increasing the configuration parameter "max_fsm_pages"
to a value over 1277312.
VACUUM

I did a vacuum verbose.
postgres=# vacuum verbose;

and below is the result i got.

INFO: free space map contains 1045952 pages in 1896 relations
DETAIL: A total of 819200 page slots are in use (including overhead).
1114192 page slots are required to track all free space.
Current limits are: 819200 page slots, 2000 relations, using 5007 kB.
NOTICE: number of page slots needed (1114192) exceeds max_fsm_pages
(819200)
HINT: Consider increasing the configuration parameter "max_fsm_pages"
to a value over 1114192.
VACUUM

As from the postgres documentation, it was advice to set it to 20K to
200K which my current setting is set to 819200 which also over 200K
already, so i just wonder what is the max number that i can set for
the max_fsm_pages?

Is that any impact if i set the value to over 2M ?

Thanks.

Regards,
Chio Chuan

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Cesar Martin 2012-04-04 09:42:20 Re: H800 + md1200 Performance problem
Previous Message David Kerr 2012-04-04 01:51:30 Re: pg_autovacuum in PG9.x