Skip site navigation (1) Skip section navigation (2)

Re: Comparitive UPDATE speed

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Comparitive UPDATE speed
Date: 2002-10-04 18:25:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Fri, Oct 04, 2002 at 11:13:09AM -0700, Josh Berkus wrote:
> Andrew,
> > 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.
> Here it is:

Oops, sorry.  What if you force the index use here?  Just because the
planner thinks that's more expensive doesn't mean that it is.


Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info>                              M2P 2A8
                                         +1 416 646 3304 x110

In response to


pgsql-performance by date

Next:From: Tom LaneDate: 2002-10-04 18:47:47
Subject: Re: Pinning a table into memory
Previous:From: Josh BerkusDate: 2002-10-04 18:13:09
Subject: Re: Comparitive UPDATE speed

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group