On 24/07/07 05:31 +1000, Nick Urbanik wrote:
>On 15/05/07 20:28 -0500, Jim C. Nasby wrote:
>>On Wed, May 16, 2007 at 11:20:52AM +1000, Nick Urbanik wrote:
>>>On 15/05/07 21:12 -0400, Alvaro Herrera wrote:
>>> >Nick Urbanik wrote:
>>> >>On 15/05/07 18:53 -0400, Alvaro Herrera wrote:
>>> >You probably need to better configure the FSM settings. See
>>> >fsm_max_pages in the docs.
>>>This is probably the critical piece of information we need to prevent
>>>the need for another sleepless night and an outage! Thank you.
>>might be of use as well.
>I have not been able to find this page; pervasive have moved their
>site around. Any keywords in this article I can google for to find
>the new URL?
Thanks: I found a cache of the article, which is entitled,
"Q10087 - INFO: Is PostgreSQL remembering what you vacuumed?"
A simplistic summary is to do a full, verbose vacuum of the entire
postgresql installation (of all the databases together), and then the
last two lines contain output about FSM utilisation.
The values of max_fsm_relations and max_fsm_pages should then be set
in postgresql.conf in light of this information.
Nick Urbanik RHCE http://nicku.org nicku(at)nicku(dot)org
GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24
In response to
pgsql-admin by date
|Next:||From: De Leeuw Guy||Date: 2007-07-23 21:06:47|
|Subject: trigger bugs ? and suggestions|
|Previous:||From: Nick Urbanik||Date: 2007-07-23 19:31:44|
|Subject: Re: How overcome wait for vacuum full?|