Re: FETCH FIRST clause WITH TIES option - Mailing list pgsql-hackers

From Surafel Temesgen
Subject Re: FETCH FIRST clause WITH TIES option
Date
Msg-id CALAY4q-QkLU7aYrtoa2fdOhwdmkvydgRbcxXAhUjcj=qH206ng@mail.gmail.com
Whole thread Raw
In response to Re: FETCH FIRST clause WITH TIES option  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers


On Mon, Nov 11, 2019 at 5:56 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
First, I noticed that there's a significant unanswered issue from Andrew
Gierth about this using a completely different mechanism, namely an
implicit window function.  I see that Robert was concerned about the
performance of Andrew's proposed approach, but I don't see any reply
from Surafel on the whole issue.


i don't know much about window function implementation but am sure teaching window
function about limit and implementing limit variant on top of it will not be much simpler
and performant than the current implementation. i also think more appropriate place to
include limit variant is limitNode not other place which can case redundancy  and
maintainability issue

regards
Surafel

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Coding in WalSndWaitForWal
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: [proposal] recovery_target "latest"