Re: KNN-GiST with recheck

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: KNN-GiST with recheck
Date: 2015-05-15 21:48:22
Message-ID: CAPpHfdvj1D-Yq7L3vqqeZ6BZxiEjXGR6SgFvSFuTn7_iFKkntw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, May 15, 2015 at 2:49 PM, Alexander Korotkov <aekorotkov(at)gmail(dot)com>
wrote:

> On Fri, May 15, 2015 at 2:48 PM, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
> wrote:
>
>> On 05/15/2015 11:31 AM, Alexander Korotkov wrote:
>>
>>> On Fri, May 15, 2015 at 2:30 AM, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
>>> wrote:
>>>
>>> On 05/15/2015 02:28 AM, Heikki Linnakangas wrote:
>>>>
>>>> I think this is now ready for committing, but I'm pretty tired now so
>>>>> I'll read through this one more time in the morning, so that I won't
>>>>> wake up to a red buildfarm.
>>>>>
>>>>>
>>>> Forgot to attach the latest patch, here you go.
>>>>
>>>
>>>
>>> Looks good for me.
>>>
>>
>> Ok, pushed after some further minor cleanup.
>
>
> Great! Thank you!
>

BTW, I found that now IndexScan node lackof copy and output support for
indexorderbyops.
Attached patch fixes that. Copy and output functions assume that
indexorderbyops has the same length as indexorderby. In order to make this
more evident I move check for best_path->path.pathkeys in create_plan from
"if" into assertion. AFAICS, pathkeys should always present where there are
indexorderby.

------
With best regards,
Alexander Korotkov.

Attachment Content-Type Size
fix-indexscan-node.patch application/octet-stream 2.8 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2015-05-15 21:49:38 Re: Problems with question marks in operators (JDBC, ECPG, ...)
Previous Message Jim Nasby 2015-05-15 21:44:38 Re: i feel like compelled !