Alvaro Herrera wrote:
> I came up with the following patch. What this does is cancel any
> ANALYZE started by autovacuum, at the top of ALTER TABLE.
There's a small race condition, autoanalyze could start between the
calls autovac_cancel_analyze and relation_open.
And it doesn't solve the problem for autovacuum. Or other commands than
ALTER TABLE, like CLUSTER.
> There is a new function relation_openrv_cav(). This is the same as
> relation_openrv, except that it will also cancel analyzes. I'm still
> wondering if I should merge the two and have a third boolean argument to
> specify whether to do the cancel.
I like it better the way you have it now.
In response to
pgsql-hackers by date
|Next:||From: Guillaume Smet||Date: 2007-10-04 12:53:16|
|Subject: Re: First steps with 8.3 and autovacuum launcher|
|Previous:||From: Michael Meskes||Date: 2007-10-04 07:59:18|
|Subject: Re: Not *quite* there on ecpg fixes|