Re: [GENERAL] Full vacuum may reclaim space

2007-06-12 Thread Gino . Barille
On May 31, 12:11 am, [EMAIL PROTECTED] (Tom Lane) wrote: > [EMAIL PROTECTED] 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

Re: [GENERAL] Full vacuum may reclaim space

2007-05-30 Thread Tom Lane
[EMAIL PROTECTED] 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 co

[GENERAL] Full vacuum may reclaim space

2007-05-30 Thread Gino . Barille
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? ---(end of broadcast)--- TIP 5: don't forget to increase your free s

Re: [GENERAL] Full vacuum may reclaim space

2007-05-30 Thread Hannes Dorbath
On 30.05.2007 14:28, [EMAIL PROTECTED] 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 q