Postgres Pro
Downloads
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
Msg-id CAGMVOdvAfKzfjDoA747fGNxYKdXG3rBiqRnwaz=FTcqW1TyOOA@mail.gmail.com
Whole thread Raw
In response to Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options
List pgsql-hackers
Tree view
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. 
Attachment

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Incorrect assert in libpqwalreceiver
Next
From: David Rowley
Date:
Subject: Re: maintenance_work_mem = 64kB doesn't work for vacuum