| From: | "Gauri Kanekar" <meetgaurikanekar(at)gmail(dot)com> |
|---|---|
| To: | "Brad Nicholson" <bnichols(at)ca(dot)afilias(dot)info> |
| Cc: | "Peter Childs" <peterachilds(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Replication Syatem |
| Date: | 2008-04-28 14:17:22 |
| Message-ID: | 7e4ba9550804280717w496ac1a0ic3c55ba664a48c9b@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Thats one of the thingsto be done in near future.
But it need some changes from application point of view. :( ... so just got
escalated for that reason.
But for now, which one will be a well suited replication system ?
~ Gauri
On Mon, Apr 28, 2008 at 7:43 PM, Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
wrote:
>
> 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.
>
>
--
Regards
Gauri
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gauri Kanekar | 2008-04-28 14:18:48 | Re: Replication Syatem |
| Previous Message | salman | 2008-04-28 14:16:44 | Re: Replication Syatem |