Re: pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN.
Christoph Berg <myon@debian.org>
From: Christoph Berg <myon@debian.org>
To: Tatsuo Ishii <ishii@postgresql.org>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2025-03-31T15:40:20Z
Lists: pgsql-hackers
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
Commits
-
Fix failing regression test on x86-32 machines
- 3dbdf86c6364 18.0 landed
-
Add memory/disk usage for Window aggregate nodes in EXPLAIN.
- 95d6e9af07d2 18.0 cited