Postgres Pro
Downloads
Home   >   mailing lists

number of page slots needed (1576544) exceeds max_fsm_pages (204800)] - Mailing list pgsql-general

From Reid Thompson
Subject number of page slots needed (1576544) exceeds max_fsm_pages (204800)]
Date
Msg-id 20100118184731.GG6399@ateb.com
Whole thread Raw
Responses Re: number of page slots needed (1576544) exceeds max_fsm_pages (204800)]  (Vick Khera <vivek@khera.org>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Martin Flahault
Date:
Subject: Re: Collate order on Mac OS X, text with diacritics in UTF-8
Next
From: Rodrigo Valdenegro
Date:
Subject: PostreSQL PostgreSQL 8.1.18 and Tsearch2 context error