bloating vacuum

From: S H <msq001(at)live(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: bloating vacuum
Date: 2013-05-14 14:51:55
Message-ID: BAY155-W7C170A3E15E9A0A9B7B10FDA10@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reid Thompson 2013-05-14 14:57:43 Re: bloating vacuum
Previous Message kristian kvilekval 2013-05-14 14:48:40 Re: postgres and xquery