Re: I don't understand that EXPLAIN PLAN timings

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: I don't understand that EXPLAIN PLAN timings
Дата
Msg-id 456126.1706218347@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: I don't understand that EXPLAIN PLAN timings  (David Rowley <dgrowleyml@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: I don't understand that EXPLAIN PLAN timings
Следующее
От: Jean-Christophe Boggio
Дата:
Сообщение: Re: I don't understand that EXPLAIN PLAN timings