On Tue, May 14, 2013 at 7:51 AM, S H <[email protected]> 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?
>
