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.
На чт, 13.03.2025 г. в 9:49 Oliver Ford <ojf...@gmail.com> написа: > > > On Sun, 9 Mar 2025, 20:07 Oliver Ford, <ojf...@gmail.com> wrote: > >> On Sun, Mar 9, 2025 at 6:40 AM Tatsuo Ishii <is...@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 > >>
