Re: How overcome wait for vacuum full? - Mailing list pgsql-admin

From Nick Urbanik
Subject Re: How overcome wait for vacuum full?
Date
Msg-id 20070723202514.GB25451@nicku.org
Whole thread Raw
In response to Re: How overcome wait for vacuum full?  (Nick Urbanik <nicku@nicku.org>)
List pgsql-admin
Dear Folks,

On 24/07/07 05:31 +1000, Nick Urbanik wrote:
>Dear Jim,
>
>On 15/05/07 20:28 -0500, Jim C. Nasby wrote:
>>On Wed, May 16, 2007 at 11:20:52AM +1000, Nick Urbanik wrote:
>>>Dear Alvaro,
>>>
>>>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.
>>
>>http://www.pervasive-postgres.com/instantkb13/article.aspx?id=10087&cNode=5K1C3W
>>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?"


http://72.14.253.104/search?q=cache:n_LQiTbm9joJ:www.pervasivepostgres.com/instantkb13/article.aspx%3Fid%3D10087+%22Is+PostgreSQL+remembering+what+you+vacuumed%3F%22&hl=en&ct=clnk&cd=2&gl=au

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@nicku.org
GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24

Attachment

pgsql-admin by date:

Previous
From: Nick Urbanik
Date:
Subject: Re: How overcome wait for vacuum full?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: update within trigger function