Re: bloating vacuum

Поиск
Список
Период
Сортировка
Искать
От
bricklen
Тема
Re: bloating vacuum
Дата
в 15:06:28
Msg-id
CAGrpgQ_RNeRxjkfZ8AE1HP3K3r8PCt8WWivC5_vsStHGr5zcSg@mail.gmail.com
Ответ на
bloating vacuum (S H)
Список
Дерево обсуждения
bloating vacuum S H <msq001@live.com>
Re: bloating vacuum bricklen <bricklen@gmail.com>
Re: bloating vacuum Reid Thompson <Reid.Thompson@ateb.com>
Re: bloating vacuum S H <msq001@live.com>
Re: bloating vacuum Scott Marlowe <scott.marlowe@gmail.com>
On Tue, May 14, 2013 at 7:51 AM, S H <msq001@live.com> wrote:

 I created small table and started doing insertion/deletion/updation on 2 rows in infinite loop. It started bloating around 844 times, but after it stopped bloating.. what could be the reason?


Did autovacuum kick in and clean up the table?
Is autovacuum on? Type:
show autovacuum;

You can watch the dead tuple count  using *pgstattuple (an extension which can be installed via "create extension pgstattuple;".
Once installed,
select * from pgstattuple('name_of_your_table');

 

In between i am running manual vacuum analyze ( without full option)

 After every iteration? 

В списке pgsql-general по дате отправления
Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: postgres and xquery
Следующее
От: Igor Neyman
Дата:
FAQ