Re: bloating vacuum

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

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

> In between i am running manual vacuum analyze ( without full option)
>
After every iteration?

>