Re: Cleaning up large objects

From: Kris Jurka <books(at)ejurka(dot)com>
To: Ole Streicher <ole-usenet-spam(at)gmx(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Cleaning up large objects
Date: 2004-08-10 17:38:26
Message-ID: Pine.BSO.4.56.0408101236340.26464@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2004-08-10 17:52:06 Re: Cleaning up large objects
Previous Message Ole Streicher 2004-08-10 15:33:33 Re: Cleaning up large objects