Re: FSM and VM file

From: Richard Huxton <dev(at)archonet(dot)com>
To: akp geek <akpgeek(at)gmail(dot)com>
Cc: Scott Mead <scott(dot)lists(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: FSM and VM file
Date: 2010-03-03 13:37:09
Message-ID: 4B8E6605.20603@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-03-03 13:53:43 Re: FSM and VM file
Previous Message akp geek 2010-03-03 13:32:56 Re: FSM and VM file