Re: Full vacuum may reclaim space

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gino(dot)Barille(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Full vacuum may reclaim space
Date: 2007-05-30 22:11:33
Message-ID: 21998.1180563093@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gino(dot)Barille(at)gmail(dot)com writes:
> 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?

There are several corner cases where the code will abandon shrinking.
What are you concerned about exactly?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-05-30 22:14:26 Re: How to implement GOMONTH function
Previous Message Merlin Moncure 2007-05-30 21:45:49 Re: Problems with createdb.exe and createuser.exe