Re: Teaching query_planner to handle multiple sort orders?

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Teaching query_planner to handle multiple sort orders?
Date: 2017-01-07 16:45:48
Message-ID: 87y3ymyg7k.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

>> Of course there is one good solution, which is to have query_planner
>> take a set of acceptable output sort orders rather than just a
>> single one.

>> How wild an idea is this?

Tom> It's been on my to-do list for years, see e.g.
Tom> https://postgr.es/m/5702.1480896563@sss.pgh.pa.us

Tom> The idea wouldn't have been very helpful before the upper planner
Tom> got path-ified, but now the only stumbling block is a shortage of
Tom> round tuits.

I'll take a shot at it, then.

--
Andrew (irc:RhodiumToad)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kuntal Ghosh 2017-01-07 17:07:57 Re: Incorrect XLogRegisterBuffer flag for revmapbuf in brin
Previous Message Tom Lane 2017-01-07 16:27:47 Re: Teaching query_planner to handle multiple sort orders?