Re: Why am I getting this error in DB - Mailing list pgsql-general

From Ben Chobot
Subject Re: Why am I getting this error in DB
Date
Msg-id 02ABD2BA-4264-4FB9-B346-A81AC40A0239@silentmedia.com
Whole thread Raw
In response to Re: Why am I getting this error in DB  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
On Feb 16, 2010, at 9:39 PM, AI Rumman wrote:

> How should I calculate the value of max_fsm_pages?

Adding pages is cheap, so I would take the value it says you need (858976) and bring it up to the next power of 10.
Especiallybecause changing it requires a restart. Of course, if you've been doing more or less updates/deletes than
normal,adjust appropriately. 

Or just upgrade to 8.4, which doesn't need this knob anymore. :)

pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: Re: Why am I getting this error in DB
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: Source RPMs for PostgreSQL 7.4.27 on RHEL4