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

Re: pgsql: Extract catalog info for error reportingbefore an error actually

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-committers(at)postgresql(dot)org, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgsql: Extract catalog info for error reportingbefore an error actually
Date: 2007-10-25 16:56:30
Message-ID: 1193331390.4242.305.camel@ebony.site (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackerspgsql-patches
On Thu, 2007-10-25 at 13:41 -0300, Alvaro Herrera wrote:
> Simon Riggs wrote:
> > On Thu, 2007-10-25 at 14:45 +0000, Alvaro Herrera wrote:
> > > Log Message:
> > > -----------
> > > Extract catalog info for error reporting before an error actually happens.
> > > Also, remove redundant reset of for-wraparound PGPROC flag.
> > 
> > Just noticed you've made these changes. I was working on them, but
> > hadn't fully tested the patch because of all the different touch points.
> > Sorry for the delay.
> > 
> > Would you like me to refresh my earlier patch against the newly
> > committed state (or did you commit that aspect already as well?).
> 
> I am doing just that.  I'll post it soon.

OK thanks.

> 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.

-- 
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


In response to

Responses

pgsql-hackers by date

Next:From: Michael PaesoldDate: 2007-10-25 17:09:08
Subject: Re: [HACKERS] Re: pgsql: Extract catalog info for error reporting before an error actually
Previous:From: Alvaro HerreraDate: 2007-10-25 16:41:50
Subject: Re: pgsql: Extract catalog info for error reportingbefore an error actually

pgsql-committers by date

Next:From: Michael PaesoldDate: 2007-10-25 17:09:08
Subject: Re: [HACKERS] Re: pgsql: Extract catalog info for error reporting before an error actually
Previous:From: Alvaro HerreraDate: 2007-10-25 16:41:50
Subject: Re: pgsql: Extract catalog info for error reportingbefore an error actually

pgsql-patches by date

Next:From: Michael PaesoldDate: 2007-10-25 17:09:08
Subject: Re: [HACKERS] Re: pgsql: Extract catalog info for error reporting before an error actually
Previous:From: Alvaro HerreraDate: 2007-10-25 16:41:50
Subject: Re: pgsql: Extract catalog info for error reportingbefore an error actually

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