Re: Using EXPLAIN in regressions?

From: Neil Conway <neilc(at)samurai(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Joshua Reich <josh(at)root(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Using EXPLAIN in regressions?
Date: 2006-07-20 22:51:27
Message-ID: 1153435887.5476.3.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2006-07-20 23:13:34 Re: [PATCHES] 8.2 features?
Previous Message Tom Lane 2006-07-20 22:19:54 Re: Using EXPLAIN in regressions?