Re: FETCH FIRST clause PERCENT option

From: Surafel Temesgen <surafel3000(at)gmail(dot)com>
To: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: vik(dot)fearing(at)2ndquadrant(dot)com, Mark Dilger <hornschnorter(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, andrew(at)tao11(dot)riddles(dot)org(dot)uk
Subject: Re: FETCH FIRST clause PERCENT option
Date: 2019-02-01 11:10:38
Message-ID: CALAY4q_v1p6PimdNUhpqgUY4E1Vv3-81Wm9JPKKZ9DfxCn8h9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

here is a rebased version of previous patch with planner
comment included

regards
Surafel

On Wed, Jan 30, 2019 at 9:07 AM Surafel Temesgen <surafel3000(at)gmail(dot)com>
wrote:

>
>
> On Mon, Jan 28, 2019 at 1:28 AM Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
> wrote:
>
>>
>>
>> OK. Does that mean you agree the incremental approach is reasonable?
>>
>
> there are no noticeable performance difference but i love previous
> approach more regarding cursor operation it fetch tuple forward and
> backward from tuplestore only but in incremental approach we have to
> re execute outer node in every forward and backward fetching operation
>
> regards
> Surafel
>

Attachment Content-Type Size
fetch-with-percent-v8.patch text/x-patch 40.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message rajan 2019-02-01 11:24:57 Re: where clause not working through psql command line client
Previous Message Dmitry Dolgov 2019-02-01 11:02:28 Re: [HACKERS] [PATCH] Generic type subscripting