Re: EXPLAIN (plan off, rewrite off) for benchmarking - Mailing list pgsql-hackers

From Tom Lane
Subject Re: EXPLAIN (plan off, rewrite off) for benchmarking
Date
Msg-id 29067.1321926871@sss.pgh.pa.us
Whole thread Raw
In response to Re: EXPLAIN (plan off, rewrite off) for benchmarking  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: EXPLAIN (plan off, rewrite off) for benchmarking
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> ... Maybe we could find a way to reduce the size of the parse
> tree (i.e. fewer nodes), or the number of times that it has to be
> walked/copied.

We could eliminate some annoying tree-copy steps if we could institute
the policy that parse analysis doesn't scribble on the raw parse tree,
rewriter doesn't modify parse analysis output, and planner doesn't
modify rewriter output.  However, it would be a lot of work, and I'm not
entirely sure that we'd end up with a significant speed benefit.  In a
lot of places, the only way to not scribble on the input is to copy it
anyway ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Rudyar
Date:
Subject: explain analyze query execution time
Next
From: Tom Lane
Date:
Subject: Re: btvacuumpage useless "orig_blkno"