Re: FSM and VM file

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: FSM and VM file
Дата
Msg-id 4B8E6605.20603@archonet.com
обсуждение исходный текст
Ответ на Re: FSM and VM file  (akp geek <akpgeek@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: akp geek
Дата:
Сообщение: Re: FSM and VM file
Следующее
От: Herouth Maoz
Дата:
Сообщение: stopping processes, preventing connections