Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Re: pgsql: Extract catalog info for error reporting before an error actually

From: Michael Paesold <mpaesold(at)gmx(dot)at>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-committers(at)postgresql(dot)org, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Re: pgsql: Extract catalog info for error reporting before an error actually
Date: 2007-10-25 17:09:08
Message-ID: 4720CDB4.6070501@gmx.at (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackerspgsql-patches
Simon Riggs wrote:
> On Thu, 2007-10-25 at 13:41 -0300, Alvaro Herrera wrote:
...
>> FWIW I disagree with cancelling just any autovac work automatically; in
>> my patch I'm only cancelling if it's analyze, on the grounds that if
>> you have really bad luck you can potentially lose a lot of work that
>> vacuum did.  We can relax this restriction when we have cancellable
>> vacuum.
> 
> That was requested by others, not myself, but I did agree with the
> conclusions. The other bad luck might be that you don't complete some
> critical piece of work in the available time window because an automated
> job kicked in.

Yeah, I thought we had agreed that we must cancel all auto 
vacuum/analyzes, on the ground that foreground operations are usually 
more important than maintenance tasks. Remember the complaint we already 
had on hackers just after beta1: auto *vacuum* blocked a schema change, 
and of course the user complained.

Best Regards
Michael Paesold



In response to

Responses

pgsql-hackers by date

Next:From: J. Andrew RogersDate: 2007-10-25 17:21:47
Subject: Re: Opportunity for a Radical Changes in Database Software
Previous:From: Simon RiggsDate: 2007-10-25 16:56:30
Subject: Re: pgsql: Extract catalog info for error reportingbefore an error actually

pgsql-committers by date

Next:From: Alvaro HerreraDate: 2007-10-25 17:23:02
Subject: Re: [HACKERS] Re: pgsql: Extract catalog info forerror reporting before an error actually
Previous:From: Simon RiggsDate: 2007-10-25 16:56:30
Subject: Re: pgsql: Extract catalog info for error reportingbefore an error actually

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2007-10-25 17:23:02
Subject: Re: [HACKERS] Re: pgsql: Extract catalog info forerror reporting before an error actually
Previous:From: Simon RiggsDate: 2007-10-25 16:56:30
Subject: Re: pgsql: Extract catalog info for error reportingbefore an error actually

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group