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 c
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
"P. Dwayne Miller" <[EMAIL PROTECTED]> writes:
> Any places to look that might explain the results of explain?
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/performance-tips.html
If you're still confused, feel free to post the query, table schemas,
and EXPLAIN output.
BTW, have yo
