Re: Cleaning up large objects - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Cleaning up large objects
Date
Msg-id Pine.BSO.4.56.0408101236340.26464@leary.csoft.net
Whole thread Raw
In response to Re: Cleaning up large objects  ("Ole Streicher" <ole-usenet-spam@gmx.net>)
List pgsql-jdbc

On Tue, 10 Aug 2004, Ole Streicher wrote:

> When I execute "vacuum -a -v -z", I get
> However, no space is freed. Why?
>

Without -f (FULL) vacuum will not actually free space, but just mark it
for later reuse.  If you are seeing a growing rate over time that you
think should hit a steady state, perhaps your free space map settings
aren't large enough.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cleaning up large objects
Next
From: "Luke (Terry) Vanderfluit"
Date:
Subject: jdk1.5Beta2 and postgres 7.4.3