Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Cc: ashutosh(dot)bapat(dot)oss(at)gmail(dot)com, orlovmg(at)gmail(dot)com, jian(dot)universality(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN
Date: 2024-09-19 03:22:11
Message-ID: CAApHDvrTXRw3yhwWfMV+4Z-Sza4Ycqn4KbkTaQxu0H1vht+OpA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 19 Sept 2024 at 13:49, Tatsuo Ishii <ishii(at)postgresql(dot)org> wrote:
>
> > That code could be modified to swap the tuplestores and do a
> > tuplestore_clear() instead of tuplestore_end() followed by
> > tuplestore_begin_heap().
> >
> Impressive result. I also ran your query with count 1000.

I've pushed that patch. That should now unblock you on the
nodeRecursiveunion.c telemetry.

David

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message jian he 2024-09-19 03:30:00 Re: not null constraints, again
Previous Message Alexander Lakhin 2024-09-19 03:00:00 Re: Should rolpassword be toastable?