Re: FSM and VM file - Mailing list pgsql-general

From Richard Huxton
Subject Re: FSM and VM file
Date
Msg-id 4B8E6605.20603@archonet.com
Whole thread Raw
In response to Re: FSM and VM file  (akp geek <akpgeek@gmail.com>)
List 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

pgsql-general by date:

Previous
From: akp geek
Date:
Subject: Re: FSM and VM file
Next
From: Herouth Maoz
Date:
Subject: stopping processes, preventing connections