bloating vacuum - Mailing list pgsql-general

From S H
Subject bloating vacuum
Date
Msg-id BAY155-W7C170A3E15E9A0A9B7B10FDA10@phx.gbl
Whole thread Raw
Responses Re: bloating vacuum
Re: bloating vacuum
List pgsql-general

I am doing some experiment to understand the behaviour of manual vacuum.

 

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?


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

 

pgsql-general by date:

Previous
From: kristian kvilekval
Date:
Subject: Re: postgres and xquery
Next
From: Reid Thompson
Date:
Subject: Re: bloating vacuum