Re: bloating vacuum

From: Reid Thompson <Reid(dot)Thompson(at)ateb(dot)com>
To: S H <msq001(at)live(dot)com>
Cc: Reid Thompson <Reid(dot)Thompson(at)ateb(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: bloating vacuum
Date: 2013-05-14 14:57:43
Message-ID: F956DEF56F298E4594A443DE460BC47D45A69C77@sr101-exch1.ateb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2013-05-14 at 14:51 +0000, S H wrote:
> 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)

Explanation is described here
http://www.postgresql.org/docs/9.1/static/sql-vacuum.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2013-05-14 15:05:01 Re: postgres and xquery
Previous Message S H 2013-05-14 14:51:55 bloating vacuum