Re: Recovering real disk space

Isn't this also a symptom of inappropriate FSM settings?

Try running a VACUUM VERBOSE and check the FSM settings at the end.

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source — Open Your i™

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Apr 3, 2005, at 8:21 AM, Bruno Wolff III wrote:

> On Wed, Mar 30, 2005 at 13:09:33 -0500,
>   Adam Siegel <adam@sycamore.us> wrote:
>>
>> We perform a vacuum full after each mass delete.  This cycle can
>> happen
>> many times during over a couple of weeks.  We are in a test lab
>> environment and are generating a lot of data.
>>
>> One of the problems we have is that the vacuum on the table can take
>> up
>> to 10 hours.  We also expect to see the physical disk space go down,
>> but
>> this does not happen.  If we accidently fill up the disk, then all
>> bets
>> are off and we are unable to recover.  A vacuum never seems to finish
>> (several days).
>
> This may mean that there are open transactions pinning the records you
> have deleted so that they aren't being removed by the vacuum.
> Also, under some circumstances a CLUSTER can be faster than a VACUUM
> FULL.