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

Re: Is there any other way to do this?

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Is there any other way to do this?
Date: 2005-05-17 22:57:26
Message-ID: 20050517225726.GA24185@uio.no (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, May 17, 2005 at 06:58:20PM -0400, Wei Weng wrote:
> This time it worked! But VACUUM FULL requires an exclusive lock on the 
> table which I don't really want to grant. So my question is: why is VACUUM 
> ANALYZE didn't do the job? Is there any setting I can tweak to make a 
> VACUUM without granting a exclusive lock?

You just didn't vacuum often enough. Plain VACUUM (with ANALYZE or not) only
deletes dead rows, it does not reclaim the space used for them (and thus does
not compress the remaining ones into fewer pages, so they take less time to
scan). If you simply VACUUM regularily (try autovacuum from contrib, it will
probably be useful) the problem simply will never be as bad as you describe
here, and you won't need to VACUUM FULL.

/* Steinar */
-- 
Homepage: http://www.sesse.net/

In response to

pgsql-performance by date

Next:From: Wei WengDate: 2005-05-17 22:58:20
Subject: Is there any other way to do this?
Previous:From: listsDate: 2005-05-17 17:53:39
Subject: Re: Trigger performance problem

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