Horton

Re: Comparitive UPDATE speed

Andrew Sullivan <andrew@libertyrms.info>

View thread View on postgr.es
From: Andrew Sullivan <andrew@libertyrms.info>
To: pgsql-performance@postgresql.org
Date: 2002-10-04T16:44:03Z
Lists: pgsql-performance 
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