> I'm not sure about 20 times longer but you would have index records
> would need to be changed. Is field_3 indexed in all 3 tables? If
> does not have an index on field_3 and the other tables do, I'd guess
> would make this take longer too.
Yeah, they're indexed. I'm going to try the updates without the index
on field_2 tonight.
pgsql-performance by date
|Next:||From: Ron Johnson||Date: 2002-10-02 10:48:01|
|Subject: Re: Comparitive UPDATE speed|
|Previous:||From: Josh Berkus||Date: 2002-10-01 21:51:29|
|Subject: Comparitive UPDATE speed|