| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Michael Paesold <mpaesold(at)gmx(dot)at>, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Gregory Stark <stark(at)enterprisedb(dot)com>, Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: First steps with 8.3 and autovacuum launcher |
| Date: | 2007-10-12 17:30:30 |
| Message-ID: | 1192210230.4233.585.camel@ebony.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 2007-10-12 at 12:42 -0400, Tom Lane wrote:
> Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> > On Fri, 2007-10-12 at 11:26 -0400, Tom Lane wrote:
> >> Why not SIGINT?
>
> > I must be missing something. How would I tell the difference between
> > manual and automatic cancels if we use SIGINT for both cases?
>
> Why do you need to? I thought the plan was that DeadlockCheck would
> only try to signal autovac workers.
...thinks...
On Fri, 2007-10-12 at 10:19 -0400, Tom Lane wrote:
> In short: put in the automatic lock cancel for regular vacuums, disable
> it for antiwraparound vacuums, but don't disable manual cancels; and
> definitely don't invent a complicated new set of behaviors around that.
So you mean "dont allow automatic cancels of manually submitted
VACUUMs".
I thought you meant don't disable manually-requested cancels of
autovacuums.
Can you explain further what you meant by "don't disable manual
cancels".
(laughs) wish I had a pound for every time we'd misunderstood each
other, or at least, a pound every time I misunderstood you. :-)
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Mayer | 2007-10-12 17:37:33 | Re: Release notes introductory text |
| Previous Message | Magnus Hagander | 2007-10-12 17:14:45 | Re: pg_tablespace_size() |