Home > mailing lists

Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options - Mailing list pgsql-hackers

From	Oliver Ford
Subject	Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options
Date	March 13 10:49:03
Msg-id	CAGMVOduuhBa5b9ZzsJ2EwQZKFJhtjx3j4xwmbvfNo8Oks63mZw@mail.gmail.com Whole thread Raw
In response to	Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options (Oliver Ford <ojford@gmail.com>)
Responses	Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options
List	pgsql-hackers

Tree view

On Sun, 9 Mar 2025, 20:07 Oliver Ford, <ojford@gmail.com> wrote:

On Sun, Mar 9, 2025 at 6:40 AM Tatsuo Ishii <ishii@postgresql.org> wrote:
> Attached version removes the non-nulls array. That seems to speed
> everything up. Running the above query with 1 million rows averages 450ms,
> similar when using lead/lag.

Great. However, CFbot complains about the patch:

https://cirrus-ci.com/task/6364194477441024

Attached fixes the headerscheck locally.

v11 attached because the previous version was broken by commit 8b1b342

Attachment

0011-ignore-nulls.patch

pgsql-hackers by date:

From: Masahiko Sawada
Date: 13 March, 10:19:53
Subject: Re: Parallel heap vacuum

From: Richard Guo
Date: 13 March, 10:53:08
Subject: Re: Wrong results with subquery pullup and grouping sets

Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options - Mailing list pgsql-hackers

Attachment

Previous

Next