From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Claudio Freire <klaussfreire(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Abhijit Menon-Sen <ams(at)2ndquadrant(dot)com>, PostgreSQL-Dev <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: allowing VACUUM to be cancelled for conflicting locks |
Date: | 2014-04-28 18:07:04 |
Message-ID: | 20140428180704.GF14464@awork2.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2014-04-28 14:05:04 -0400, Tom Lane wrote:
> Andres Freund <andres(at)2ndquadrant(dot)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?
Yea, I am not that sure about the feature either. It sure would need to
be optional. Often enough VACUUMs are scripted to run during off hours,
for those it possibly makes sense.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2014-04-28 18:21:05 | Re: allowing VACUUM to be cancelled for conflicting locks |
Previous Message | Tom Lane | 2014-04-28 18:05:04 | Re: allowing VACUUM to be cancelled for conflicting locks |