Re: Comparitive UPDATE speed - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Comparitive UPDATE speed
Date
Msg-id web-1736716@davinci.ethosmedia.com
Whole thread Raw
In response to Comparitive UPDATE speed  (Josh Berkus <josh@agliodbs.com>)
List 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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Comparitive UPDATE speed
Next
From: Ron Johnson
Date:
Subject: Re: Comparitive UPDATE speed