Re: [HACKERS] canceling autovacuum task woes

2012-08-30 Thread Robert Haas
On Mon, Aug 13, 2012 at 11:59 PM, Peter Eisentraut pete...@gmx.net wrote: On Tue, 2012-07-24 at 16:14 -0400, Robert Haas wrote: On Tue, Jul 24, 2012 at 4:09 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: Yeah, you're right. So you do get the table name.

Re: [HACKERS] canceling autovacuum task woes

2012-08-13 Thread Peter Eisentraut
On Tue, 2012-07-24 at 16:14 -0400, Robert Haas wrote: On Tue, Jul 24, 2012 at 4:09 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: Yeah, you're right. So you do get the table name. But you don't get the cause, which is what you really need to understand

[HACKERS] canceling autovacuum task woes

2012-07-24 Thread Robert Haas
I am running into a lot of customer situations where the customer reports that canceling autovacuum task shows up in the logs, and it's unclear whether this is happening often enough to matter, and even more unclear what's causing it. Me: So, do you know what table it's getting cancelled on?

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Andres Freund
Hi, On Tuesday, July 24, 2012 07:48:27 PM Robert Haas wrote: I am running into a lot of customer situations where the customer reports that canceling autovacuum task shows up in the logs, and it's unclear whether this is happening often enough to matter, and even more unclear what's causing

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Steve Singer
On 12-07-24 01:48 PM, Robert Haas wrote: I am running into a lot of customer situations where the customer reports that canceling autovacuum task shows up in the logs, and it's unclear whether this is happening often enough to matter, and even more unclear what's causing it. Could autovacuum

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Robert Haas
On Tue, Jul 24, 2012 at 2:11 PM, Steve Singer ssin...@ca.afilias.info wrote: On 12-07-24 01:48 PM, Robert Haas wrote: I am running into a lot of customer situations where the customer reports that canceling autovacuum task shows up in the logs, and it's unclear whether this is happening often

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Andrew Dunstan
On 07/24/2012 01:48 PM, Robert Haas wrote: I am running into a lot of customer situations where the customer reports that canceling autovacuum task shows up in the logs, and it's unclear whether this is happening often enough to matter, and even more unclear what's causing it. Me: So, do you

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Alvaro Herrera
On Tuesday, July 24, 2012 07:48:27 PM Robert Haas wrote: I am running into a lot of customer situations where the customer reports that canceling autovacuum task shows up in the logs, and it's unclear whether this is happening often enough to matter, and even more unclear what's causing

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Alvaro Herrera
Excerpts from Alvaro Herrera's message of mar jul 24 15:30:49 -0400 2012: On Tuesday, July 24, 2012 07:48:27 PM Robert Haas wrote: I am running into a lot of customer situations where the customer reports that canceling autovacuum task shows up in the logs, and it's unclear whether

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Robert Haas
On Tue, Jul 24, 2012 at 3:35 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Yep, it says: ERROR: canceling autovacuum task CONTEXT: automatic vacuum of table alvherre.public.foo So at least that part seems pilot error more than anything else. Yeah, you're right. So you do get the

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Alvaro Herrera
Excerpts from Robert Haas's message of mar jul 24 15:52:23 -0400 2012: On Tue, Jul 24, 2012 at 3:35 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Yep, it says: ERROR: canceling autovacuum task CONTEXT: automatic vacuum of table alvherre.public.foo So at least that part

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Robert Haas
On Tue, Jul 24, 2012 at 4:03 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Robert Haas's message of mar jul 24 15:52:23 -0400 2012: On Tue, Jul 24, 2012 at 3:35 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Yep, it says: ERROR: canceling autovacuum task

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: Yeah, you're right. So you do get the table name. But you don't get the cause, which is what you really need to understand why it's happening. Attached is a patch that adds some more detail. Uh, what's the added dependency on pgstat.h for? Looks

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Robert Haas
On Tue, Jul 24, 2012 at 4:09 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: Yeah, you're right. So you do get the table name. But you don't get the cause, which is what you really need to understand why it's happening. Attached is a patch that adds some

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Tue, Jul 24, 2012 at 4:03 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Looks great. Are you considering backpatching this? Well, that would certainly make MY life easier. I am not sure whether it would be in line with project policy,

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Robert Haas
On Jul 24, 2012, at 4:31 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Tue, Jul 24, 2012 at 4:03 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Looks great. Are you considering backpatching this? Well, that would certainly make MY life easier. I

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Jul 24, 2012, at 4:31 PM, Tom Lane t...@sss.pgh.pa.us wrote: ... This means that with respect to (a), the connection from the process doing the kill to the AV proc may be inadequately documented by this patch, and with respect to (b), there might