Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

Next:From: Tom LaneDate: 2004-08-10 17:52:06
Subject: Re: Cleaning up large objects
Previous:From: Ole StreicherDate: 2004-08-10 15:33:33
Subject: Re: Cleaning up large objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group