Re: Replication Syatem

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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance