Re: Full vacuum may reclaim space

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: Gino(dot)Barille(at)gmail(dot)com
Subject: Re: Full vacuum may reclaim space
Date: 2007-05-30 12:33:32
Message-ID: 465D6F1C.7020903@theendofthetunnel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 30.05.2007 14:28, Gino(dot)Barille(at)gmail(dot)com wrote:
> Other than the fact that no space may need to be reclaimed is anyone
> aware of any circumstance - e.g. use of numeric data types - where a
> full vacuum will simply not reclaim space?

- Idle transactions
- It doesn't heal index bloat, which might eat quite a bit space..

--
Regards,
Hannes Dorbath

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2007-05-30 13:48:55 Re: postgres access - pg_hba.conf
Previous Message Gino.Barille 2007-05-30 12:28:51 Full vacuum may reclaim space