Re: Tatsuo Ishii
> Add memory/disk usage for Window aggregate nodes in EXPLAIN.
This is failing for PG18 on Debian unstable on 32-bit i386:
******** build/src/test/regress/regression.diffs ********
diff -U3
/build/reproducible-path/postgresql-18-18~~devel.20250331/src/test/regress/expected/explain.out
/build/reproducible-path/postgresql-18-18~~devel.20250331/build/src/test/regress/results/explain.out
---
/build/reproducible-path/postgresql-18-18~~devel.20250331/src/test/regress/expected/explain.out
2025-03-31 06:17:21.000000000 +0000
+++
/build/reproducible-path/postgresql-18-18~~devel.20250331/build/src/test/regress/results/explain.out
2025-03-31 15:18:19.914783369 +0000
@@ -792,7 +792,7 @@
----------------------------------------------------------------------------------
WindowAgg (actual time=N.N..N.N rows=N.N loops=N)
Window: w1 AS ()
- Storage: Disk Maximum Storage: NkB
+ Storage: Memory Maximum Storage: NkB
-> Function Scan on generate_series a (actual time=N.N..N.N rows=N.N
loops=N)
Planning Time: N.N ms
Execution Time: N.N ms
This is the first build of PG18 on i386, so I cannot say if it broke with that
commit or later.
Full log:
https://buildd.debian.org/status/fetch.php?pkg=postgresql-18&arch=i386&ver=18%7E%7Edevel.20250331-1&stamp=1743434305&raw=0
Christoph
