slow update

From: "Chad Thompson" <chad(at)weblinkservices(dot)com>
To: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: slow update
Date: 2003-04-30 16:12:35
Message-ID: 094801c30f33$50c14ce0$32021aac@chad
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hey guys/gals
I have a update that is slow and I cant get my head around a way to make it
faster.

update table set id = '555'
where id in (select id from different_table)

pretty simple... i tried using exists as well.. but it still seems to be
very slow.

TIA
Chad

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2003-04-30 17:33:03 Re: slow update
Previous Message Mike Porter 2003-04-30 15:54:58