diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out /tmp/cirrus-ci-build/src/test/regress/results/workmem.out --- /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out 2025-03-16 11:18:08.750696852 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/workmem.out 2025-03-16 11:23:54.557455409 +0000 @@ -207,9 +207,10 @@ from (values (1, 1), (2, 2)) as t (a, b) where a = b group by grouping sets((a, b), (a)); '); - workmem_filter ----------------------------------------------------------------------- + workmem_filter +-------------------------------------------------------------------------------------------- WindowAgg (work_mem=N kB limit=4096 kB) + Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING) -> Sort (work_mem=N kB limit=4096 kB) Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST -> HashAggregate (work_mem=N kB limit=8192 kB) @@ -219,7 +220,7 @@ Filter: (column1 = column2) Total Working Memory: N kB Total Working Memory Limit: 16384 kB -(10 rows) +(11 rows) select a, b, row_number() over (order by a, b nulls first) from (values (1, 1), (2, 2)) as t (a, b) where a = b @@ -240,9 +241,10 @@ from (values (1, 1, 1, 1), (2, 2, 2, 2)) as t (a, b, c, d) where a = b group by grouping sets((a, b), (a), (b), (c), (d)); '); - workmem_filter ----------------------------------------------------------------------- + workmem_filter +-------------------------------------------------------------------------------------------- WindowAgg (work_mem=N kB limit=4096 kB) + Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING) -> Sort (work_mem=N kB limit=4096 kB) Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST -> GroupAggregate (work_mem=N kB limit=8192 kB) @@ -260,7 +262,7 @@ Filter: (column1 = column2) Total Working Memory: N kB Total Working Memory Limit: 20480 kB -(18 rows) +(19 rows) select a, b, row_number() over (order by a, b nulls first) from (values (1, 1, 1, 1), (2, 2, 2, 2)) as t (a, b, c, d) where a = b @@ -544,12 +546,13 @@ ------------------------------------------------------------------------------------- Limit -> WindowAgg (work_mem=N kB limit=4096 kB) + Window: w1 AS (PARTITION BY ((a.n < 3))) -> Sort (work_mem=N kB limit=4096 kB) Sort Key: ((a.n < 3)) -> Function Scan on generate_series a (work_mem=N kB limit=4096 kB) Total Working Memory: N kB Total Working Memory Limit: 12288 kB -(7 rows) +(8 rows) select sum(n) over(partition by m) from (SELECT n < 3 as m, n from generate_series(1,2000) a(n))