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

Re: Comparitive UPDATE speed

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Randy Neumann <Randy_Neumann(at)centralref(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Comparitive UPDATE speed
Date: 2002-10-01 23:50:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

> I'm not sure about 20 times longer but you would have index records
> that 
> would need to be changed.  Is field_3 indexed in all 3 tables?  If
> table_b 
> does not have an index on field_3 and the other tables do, I'd guess
> that 
> would make this take longer too.

Yeah, they're indexed.   I'm going to try the updates without the index
on field_2 tonight.

-Josh Berkus

pgsql-performance by date

Next:From: Ron JohnsonDate: 2002-10-02 10:48:01
Subject: Re: Comparitive UPDATE speed
Previous:From: Josh BerkusDate: 2002-10-01 21:51:29
Subject: Comparitive UPDATE speed

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