On Mon, Jan 18, 2010 at 12:43 PM, Vick Khera <vivek@xxxxxxxxx> wrote: > On Mon, Jan 18, 2010 at 1:47 PM, Reid Thompson <reid.thompson@xxxxxxxx> wrote: >> 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. > > My big DB is about 70 on disk. I have fsm pages set to 3.4 million, > and occasionally that gets overrun. It is nearly catastrophic to us We have about 2.8Million used and have it set to 10Million for the same reason as you do. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
