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 17288.1321717930@sss.pgh.pa.us
Whole thread Raw
In response to Re: EXPLAIN (plan off, rewrite off) for benchmarking  (Andres Freund <andres@anarazel.de>)
Responses Re: EXPLAIN (plan off, rewrite off) for benchmarking
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> Explain is just a vehicle here, I admit that. But on what else should I bolt 
> it?

If you don't like CREATE RULE, try having your test program send just
Parse messages, and not Bind/Execute.  I still dislike the idea of
exposing a fundamentally-broken-and-useless variant of EXPLAIN in order
to have a test harness for a variant of performance testing that hardly
anyone cares about.  (There is no real-world case where the performance
of the parser matters in isolation.)  If we do that, it will be a
feature that we have to support forever, and possibly fix bugs in ---
what if the system crashes because the rewriter wasn't invoked, for
example?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: foreign key locks, 2nd attempt
Next
From: Tom Lane
Date:
Subject: Re: COUNT(*) and index-only scans