On Mon, Apr 28, 2014 at 11:05 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Andres Freund <and...@2ndquadrant.com> writes: > > I don't think this is about the truncation thing, but about the > > deadlock.c/proc.c logic around DS_BLOCKED_BY_AUTOVACUUM. I.e. that a > > autovacuum is cancelled if user code tries to acquire a conflicting > > lock. > > It's a bit of a stretch to claim that a manual VACUUM should be cancelled > by a manual DDL action elsewhere. Who's to say which of those things > should have priority? > The proposal was to add either a GUC, or a syntax to the vacuum command, so it would be either DBA or the invoker of the vacuum which is the one to say. Either one does seem a reasonable place to have such a say, although perhaps not worth the effort to implement. Cheers, Jeff
