Re: pg_autovacuum not having enough suction ? - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: pg_autovacuum not having enough suction ?
Date
Msg-id 20050331221335.GB19823@phlogiston.dyndns.org
Whole thread Raw
In response to Re: pg_autovacuum not having enough suction ?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-performance
On Fri, Mar 25, 2005 at 06:21:24PM -0500, Bruce Momjian wrote:
>
> Can we issue a LOCK TABLE with a statement_timeout, and only do the
> VACUUM FULL if we can get a lock quickly?  That seems like a plan.

I think someone else's remark in this thread is important, though:
autovacuum shouldn't ever block other transactions, and this approach
will definitely run that risk.

A


--
Andrew Sullivan  | ajs@crankycanuck.ca
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
        --Alexander Hamilton

pgsql-performance by date:

Previous
From: PFC
Date:
Subject: Re: Very long time to execute and Update, suggestions?
Next
From: Steve Poe
Date:
Subject: Follow-Up: How to improve db performance with $7K?