Is it safe to use the output of EXPLAIN in regression tests? I want to
make sure that certain GiST indexes are being used by sample queries,
but I am not sure if it is safe to rely on the format of EXPLAIN to be
unchanging.
Thoughts?
Josh Reich
---(end of
Joshua Reich [EMAIL PROTECTED] writes:
Is it safe to use the output of EXPLAIN in regression tests?
No, not unless you want the test to break every other week.
I want to
make sure that certain GiST indexes are being used by sample queries,
About the best bet is to make sure that's the
On Thu, 2006-07-20 at 18:19 -0400, Tom Lane wrote:
About the best bet is to make sure that's the *only* available index,
and set enable_seqscan = off to be sure.
Another approach would be to define a UDF that takes a query string,
runs the parser, rewriter, and planner on the string and then