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

Re: Replication Syatem

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 (view raw or flat)
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

In response to

Responses

pgsql-performance by date

Next:From: Gauri KanekarDate: 2008-04-28 14:17:22
Subject: Re: Replication Syatem
Previous:From: Brad NicholsonDate: 2008-04-28 14:13:20
Subject: Re: Replication Syatem

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