From: David Rowley <dgrowle...@gmail.com> Subject: Re: pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN. Date: Tue, 1 Apr 2025 11:09:11 +1300 Message-ID: <caaphdvoohffyxuryaymxizjvyvhet0ueebojruojwn1w7e3...@mail.gmail.com>
> On Tue, 1 Apr 2025 at 09:40, Christoph Berg <m...@debian.org> wrote: >> =# explain (analyze,buffers off,costs off) select sum(n) over() from >> generate_series(1,2048) a(n); >> QUERY PLAN >> ────────────────────────────────────────────────────────────────────────────────────────── >> WindowAgg (actual time=2.073..2.686 rows=2048.00 loops=1) >> Window: w1 AS () >> Storage: Disk Maximum Storage: 65kB > > Thank you for testing that. I've just pushed a patch to bump it up to 2500. > > I suspect the buildfarm didn't catch this due to the tuplestore > consuming enough memory in MEMORY_CONTEXT_CHECKING builds. David, Christoph, Thank you for fixing this! -- Tatsuo Ishii SRA OSS K.K. English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp
