| From: | salman <salmanb(at)quietcaresystems(dot)com> |
|---|---|
| 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:16:44 |
| Message-ID: | 4815DC4C.9060509@quietcaresystems.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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 :(.
>
> Have already tried all the option listed by you, thats y we reached to the
> decision of having a replication sytsem. So any suggestion on that :).
>
> Thanx
> ~ Gauri
>
We use slony for exactly this type of a situation. It's not the most
user-friendly piece of software, but it works well enough that I can
schedule maintenance windows (we're a 24/7 shop) and do clustering and
other tasks on our DB to reclaim space, etc.
-salman
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gauri Kanekar | 2008-04-28 14:17:22 | Re: Replication Syatem |
| Previous Message | Brad Nicholson | 2008-04-28 14:13:20 | Re: Replication Syatem |