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.
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
In response to
pgsql-performance by date
|Next:||From: Steve Poe||Date: 2005-04-01 02:01:01|
|Subject: Follow-Up: How to improve db performance with $7K?|
|Previous:||From: PFC||Date: 2005-03-31 21:28:03|
|Subject: Re: Very long time to execute and Update, suggestions?|
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2005-03-31 23:23:10|
|Subject: Re: [ADMIN] Excessive growth of pg_attribute and other system tables |
|Previous:||From: Matthew T. O'Connor||Date: 2005-03-31 21:16:07|
|Subject: Re: [ADMIN] Excessive growth of pg_attribute and other system tables|