Re: sorting a union over inheritance vs pathkeys - Mailing list pgsql-hackers

From Michael Glaesemann
Subject Re: sorting a union over inheritance vs pathkeys
Date
Msg-id FAFB5A87-B574-45E1-83C3-30900227BD4F@seespotcode.net
Whole thread Raw
In response to Re: sorting a union over inheritance vs pathkeys  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Jun 25, 2014, at 22:14, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> I wrote:
>> Michael Glaesemann <grzm@seespotcode.net> writes:
>>> -- ERROR:  could not find pathkey item to sort
> 
>> Hm ... I can reproduce that in 9.3 but it seems fine in 9.4 and HEAD.
>> Don't know what's going on exactly.
> 
> Interesting --- it appears that commit
> a87c729153e372f3731689a7be007bc2b53f1410 is why it works in 9.4.  I had
> thought that was just improving plan quality, but it seems to also prevent
> this problem.  I guess we'd better back-patch it.

Thanks, Tom!

Michael Glaesemann
grzm seespotcode net






pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: Set new system identifier using pg_resetxlog
Next
From: Pavel Stehule
Date:
Subject: bad estimation together with large work_mem generates terrible slow hash joins