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 <ojford@gmail.com> написа:
On Sun, 9 Mar 2025, 20:07 Oliver Ford, <ojford@gmail.com> 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.
