Re: bloating vacuum

[bricklen <bricklen@xxxxxxxxx>]

On Tue, May 14, 2013 at 7:51 AM, S H <msq001@xxxxxxxx> 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');

*http://www.postgresql.org/docs/current/static/pgstattuple.html

 

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

 After every iteration?