Re: Postgresql performance in production environment - Mailing list pgsql-general

From Phoenix Kiula
Subject Re: Postgresql performance in production environment
Date
Msg-id e373d31e0708190521o6f113812k92ad70029eef7cd2@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql performance in production environment  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Postgresql performance in production environment
List pgsql-general
On 19/08/07, Magnus Hagander <magnus@hagander.net> wrote:
> Phoenix Kiula wrote:
> > On 19/08/07, Magnus Hagander <magnus@hagander.net> wrote:


> > should we do one (VACUUM FULL) now given that we've overrun our max_fsm_pages?
>
> Yes, but not until you've fixed it. And only once.
>



FIxed what - the max_fsm_pages? That was my question: how to know what
value to set for this. If the "vacuum verbose" won't give me the info
you suggested because it is likely overlapping with autovacuum, should
I temporarily turn autovacuum off and then run vacuum verbose? Also,
while running vacuum full, any precautions to take?

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: SUBSTRING performance for large BYTEA
Next
From: Bill Moran
Date:
Subject: Re: Seeking datacenter PITR backup procedures [RESENDING]