Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options

Поиск
Список
Период
Сортировка
От Oliver Ford
Тема Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options
Дата
Msg-id CAGMVOduuhBa5b9ZzsJ2EwQZKFJhtjx3j4xwmbvfNo8Oks63mZw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options  (Oliver Ford <ojford@gmail.com>)
Ответы Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options
Список pgsql-hackers
Дерево обсуждения


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
Вложения

В списке pgsql-hackers по дате отправления: