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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org