Re: EXPLAIN (plan off, rewrite off) for benchmarking

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: EXPLAIN (plan off, rewrite off) for benchmarking
Дата
Msg-id 27421.1321658178@sss.pgh.pa.us
обсуждение исходный текст
Ответ на EXPLAIN (plan off, rewrite off) for benchmarking  (Andres Freund <andres@anarazel.de>)
Ответы Re: EXPLAIN (plan off, rewrite off) for benchmarking  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> Hi,
> For benchmarking the parser I added the above options (dim suggested this on 
> irc) which proved to be rather useful for me.

What exactly is EXPLAIN printing, if you've not done planning?  Also, I
believe the planner depends on the assumption that the rewriter has done
its work, so these seem to amount to EXPLAIN (break_it).

If you just want to benchmark parsing, perhaps CREATE RULE would be a
useful environment.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Should a materialized view be based on a view?
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: testing ProcArrayLock patches