Re: Replication Syatem - Mailing list pgsql-performance

From Brad Nicholson
Subject Re: Replication Syatem
Date
Msg-id 1209392000.8872.29.camel@bnicholson-desktop
Whole thread Raw
In response to Re: Replication Syatem  ("Gauri Kanekar" <meetgaurikanekar@gmail.com>)
Responses Re: Replication Syatem
List 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.


pgsql-performance by date:

Previous
From: "Gauri Kanekar"
Date:
Subject: Re: Replication Syatem
Next
From: salman
Date:
Subject: Re: Replication Syatem