Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options
| От | Krasiyan Andreev |
|---|---|
| Тема | Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options |
| Дата | |
| Msg-id | CAN1PwomkQhCb50oF8cUJUkjgdwCjPKXLW10_DdoPR_baPxLi=Q@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 |
Hi,
Patch applies and compiles, all included tests passed and after the latest fixes for non-nulls array, performance is near to lead/lag without support of "ignore nulls".
I have been using the last version for more than one month in a production environment with real data and didn't find any bugs, so It is ready for committer status.
Patch applies and compiles, all included tests passed and after the latest fixes for non-nulls array, performance is near to lead/lag without support of "ignore nulls".
I have been using the last version for more than one month in a production environment with real data and didn't find any bugs, so It is ready for committer status.
На чт, 13.03.2025 г. в 9:49 Oliver Ford <ojford@gmail.com> написа:
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/6364194477441024Attached fixes the headerscheck locally.v11 attached because the previous version was broken by commit 8b1b342
В списке pgsql-hackers по дате отправления: