On Fri, Oct 04, 2002 at 08:54:56AM -0700, Josh Berkus wrote:
> Slowly. It takes about 60 seconds to return data. This may be the
> problem. Thoughts? Here's EXPLAIN output:
[. . .]
> According to the parser, using the indexes would be worse:
Have you run this with EXPLAIN ANALYSE? It will actually perform the
necessary steps, so it will reveal if the planner is getting
something wrong.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110