Salman, Slony don't do automatic failover. And we would appreciate a system with automatic failover :(
~ Gauri On Mon, Apr 28, 2008 at 7:46 PM, salman <[EMAIL PROTECTED]> wrote: > 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 > -- Regards Gauri