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 *only* available index,
and set enable_seqscan = off to be sure.
In some cases, you can use the ordering of the returned rows as a proxy
--- if they're returned in something other than heap order then it must
have used an index. I'm not sure if this will be a stable answer for
GIST indexes though.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
