Skip site navigation (1) Skip section navigation (2)

Re: Replication Syatem

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: Gauri Kanekar <meetgaurikanekar(at)gmail(dot)com>
Cc: Peter Childs <peterachilds(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Replication Syatem
Date: 2008-04-28 14:13:20
Message-ID: 1209392000.8872.29.camel@bnicholson-desktop (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, 2008-04-28 at 19:35 +0530, Gauri Kanekar wrote:
> Peter,
> 
> We are doing vacuum full every alternate day. We also do vacuum
> analyze very often.
> We are currently using 8.1.3 version.
> Auto vacuum is already on. But the table1 is so busy that auto vacuum
> don't get sufficient chance to vacuum it :(.

You should seriously consider upgrading to PG 8.3.  There have been
substantial improvements to VACUUM since 8.1

Brad.


In response to

Responses

pgsql-performance by date

Next:From: salmanDate: 2008-04-28 14:16:44
Subject: Re: Replication Syatem
Previous:From: Gauri KanekarDate: 2008-04-28 14:05:37
Subject: Re: Replication Syatem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group