Postgres Pro
Downloads
Home   >   mailing lists

Re: bloating vacuum - Mailing list pgsql-general

From bricklen
Subject Re: bloating vacuum
Date
Msg-id CAGrpgQ_RNeRxjkfZ8AE1HP3K3r8PCt8WWivC5_vsStHGr5zcSg@mail.gmail.com
Whole thread Raw
In response to bloating vacuum  (S H <msq001@live.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Rob Sargent
Date:
Subject: Re: postgres and xquery
Next
From: Igor Neyman
Date:
Subject: Re: Running out of memory on vacuum