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: web-1736716@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Johnson 2002-10-02 10:48:01 Re: Comparitive UPDATE speed
Previous Message Josh Berkus 2002-10-01 21:51:29 Comparitive UPDATE speed