Re: Using EXPLAIN in regressions? - Mailing list pgsql-hackers

From Neil Conway
Subject Re: Using EXPLAIN in regressions?
Date
Msg-id 1153435887.5476.3.camel@localhost
Whole thread Raw
In response to Re: Using EXPLAIN in regressions?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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 checks
various properties of the resulting Plan (e.g. that it includes a GiST
index scan).

-Neil




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using EXPLAIN in regressions?
Next
From: Joe Conway
Date:
Subject: Re: [PATCHES] 8.2 features?