Re: Comparitive UPDATE speed

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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110