exceeds max_fsm_pages

From: "Marc Fromm" <Marc(dot)Fromm(at)wwu(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: exceeds max_fsm_pages
Date: 2008-03-20 19:17:41
Message-ID: 81FEAB8CDDC62B42B6E8AA258228BC8804E92652@EVS2.univ.dir.wwu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


I received this message after running vacuum on a database.

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

The documentation for 8.1 sates:
This setting must be more than 16 * max_fsm_relations. The default is
20000. This option can only be set at server start.

Do I increase max_fsm_pages or max_fsm_relations, or both.
Does "only be set at server start" mean to alter the settings in
postgresql.conf and then restart the postmaster?

Marc

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Crawford 2008-03-20 22:13:49 Re: Postgres Performance
Previous Message Marc Fromm 2008-03-20 18:41:09 create db from a template