On 03/03/10 13:32, akp geek wrote:
Thank you all for the suggestions. I did a vacuum and the size has gone down drastically. But still it is not the same size as my master. I am looking into it
Check your autovacuum settings and you should be able to keep things stable at least.
You might need to cluster tables / restart the replication to get the best case. Vacuuming needs to be a continual process.
-- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
