number of page slots needed (1576544) exceeds max_fsm_pages (204800)]

From: Reid Thompson <reid(dot)thompson(at)ateb(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Cc: Reid Thompson <reid(dot)thompson(at)ateb(dot)com>
Subject: number of page slots needed (1576544) exceeds max_fsm_pages (204800)]
Date: 2010-01-18 18:47:31
Message-ID: 20100118184731.GG6399@ateb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does this max_fsm_pages value seem OK for a 46GB database?
I've clustered all the tables that seemed to be exhibiting large amounts
of bloat.

reporting=# SELECT pg_size_pretty(pg_database_size('reporting'));
pg_size_pretty
----------------
46 GB
(1 row)

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rodrigo Valdenegro 2010-01-18 19:00:57 PostreSQL PostgreSQL 8.1.18 and Tsearch2 context error
Previous Message Vincenzo Romano 2010-01-18 17:13:59 Re: postgres external table