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;".