Re: Performance regression: 9.2+ vs. ScalarArrayOpExpr vs. ORDER BY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-hackers(at)postgresql(dot)org, philip(dot)poten(at)gmail(dot)com
Subject: Re: Performance regression: 9.2+ vs. ScalarArrayOpExpr vs. ORDER BY
Date: 2014-10-26 20:15:07
Message-ID: 10447.1414354507@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wrote:
> Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
>> "Bruce" == Bruce Momjian <bruce(at)momjian(dot)us> writes:
>> Bruce> Uh, did this ever get addressed?

>> It did not.

> It dropped off the radar screen (I think I'd assumed the patch would
> appear in the next commitfest, which it didn't unless I missed something).
> I'll make a note to look at it once I've finished with the timezone
> abbreviation mess.

I've pushed this patch with some further redesign of build_index_paths'
API --- if we're going to have it reporting about what it found, we
should extend that to the other case of non-amsearcharray indexes too.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2014-10-26 20:18:03 Re: strip nulls functions for json and jsonb
Previous Message Thom Brown 2014-10-26 20:14:17 Re: strip nulls functions for json and jsonb