Horton

Re: Comparitive UPDATE speed

Josh Berkus <josh@agliodbs.com>

View thread View on postgr.es
From: "Josh Berkus" <josh@agliodbs.com>
To: Randy Neumann <Randy_Neumann@centralref.com>, pgsql-performance@postgresql.org
Date: 2002-10-01T23:50:21Z
Lists: pgsql-performance 
Randy,

> 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