Re: [RFC] Should smgrtruncate() avoid sending sinval message for temp relations - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [RFC] Should smgrtruncate() avoid sending sinval message for temp relations
Date
Msg-id 20140812150655.GB18223@awork2.anarazel.de
Whole thread Raw
In response to Re: [RFC] Should smgrtruncate() avoid sending sinval message for temp relations  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [RFC] Should smgrtruncate() avoid sending sinval message for temp relations
List pgsql-hackers
On 2014-08-12 11:04:00 -0400, Robert Haas wrote:
> On Mon, Aug 11, 2014 at 7:40 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > Robert Haas <robertmhaas@gmail.com> writes:
> >> On Fri, Aug 8, 2014 at 10:30 AM, MauMau <maumau307@gmail.com> wrote:
> >>> I've tracked down the real root cause.  The fix is very simple.  Please
> >>> check the attached one-liner patch.
> >
> >> I'd support back-porting that commit to 9.1 and 9.2 as a fix for this
> >> problem.  As the commit message says, it's dead simple.
> >
> > While I have no great objection to back-porting Heikki's patch, it seems
> > like a very large stretch to call this a root-cause fix.  At best it's
> > band-aiding one symptom in a rather fragile way.
> 
> Yeah, that's true, but I'm not clear that we have another
> back-patchable fix, so doing something almost-certainly-harmless to
> alleviate the immediate pain seems worthwhile.

Isn't that still leaving the very related issue of waits due to hot
pruning open?

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [RFC] Should smgrtruncate() avoid sending sinval message for temp relations
Next
From: Christoph Berg
Date:
Subject: Re: Hokey wrong versions of libpq in apt.postgresql.org