Re: Why am I getting this error in DB

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why am I getting this error in DB
Date: 2010-02-17 05:44:54
Message-ID: 02ABD2BA-4264-4FB9-B346-A81AC40A0239@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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. Especially because 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. :)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-02-17 06:45:52 Re: Source RPMs for PostgreSQL 7.4.27 on RHEL4
Previous Message AI Rumman 2010-02-17 05:39:55 Re: Why am I getting this error in DB