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. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
