Re: I don't understand that EXPLAIN PLAN timings - Mailing list pgsql-performance

From Tom Lane
Subject Re: I don't understand that EXPLAIN PLAN timings
Date
Msg-id 456126.1706218347@sss.pgh.pa.us
Whole thread Raw
In response to Re: I don't understand that EXPLAIN PLAN timings  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-performance
David Rowley <dgrowleyml@gmail.com> writes:
> I do wonder now if it was a bad idea to make Memoize build the hash
> table on plan startup rather than delaying that until we fetch the
> first tuple. I see Hash Join only builds its table during executor
> run.

Ouch!  If it really does that, yes it's a bad idea.

            regards, tom lane



pgsql-performance by date:

Previous
From: David Rowley
Date:
Subject: Re: I don't understand that EXPLAIN PLAN timings
Next
From: Jean-Christophe Boggio
Date:
Subject: Re: I don't understand that EXPLAIN PLAN timings