Re: bloating vacuum

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: bloating vacuum
Дата
Msg-id CAGrpgQ_RNeRxjkfZ8AE1HP3K3r8PCt8WWivC5_vsStHGr5zcSg@mail.gmail.com
обсуждение исходный текст
Ответ на bloating vacuum  (S H <msq001@live.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления: