| From: | "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Cc: | "Marc Fromm" <Marc(dot)Fromm(at)wwu(dot)edu> |
| Subject: | Re: exceeds max_fsm_pages |
| Date: | 2008-03-21 04:51:35 |
| Message-ID: | 200803202151.35336.uwe@oss4u.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
You increase max_fsm_pages and restart the server.
On Thursday 20 March 2008, Marc Fromm wrote:
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2008-03-21 08:48:59 | Re: DB Structure Recovery |
| Previous Message | Shane Ambler | 2008-03-21 00:45:40 | Re: create db from a template |