Re: HELP speed up my Postgres

From: "Anatoly Okishev" <rolly74(at)mail(dot)ru>
To: <jerome(at)gmanmi(dot)tv>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: HELP speed up my Postgres
Date: 2004-11-25 09:21:00
Message-ID: 077301c4d2d0$1608ea10$191716ac@ws5
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

> SQL:
> update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where mobile_num in (select
> mobile_num from LOADED_MOBILE_NUMBERS)

You can try this:

update SUBSCRIPTIONTABLE, LOADED_MOBILE_NUMBERS set
SUBSCRIPTIONTABLE.ACTIVEFLAG='Y'
where LOADED_MOBILE_NUMBERS.mobile_num=SUBSCRIPTIONTABLE.mobile_num

Anatoly.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bjørn T Johansen 2004-11-25 09:24:03 Index work around?
Previous Message Richard Huxton 2004-11-25 09:16:10 Re: tableoid

Browse pgsql-performance by date

  From Date Subject
Next Message ON.KG 2004-11-25 11:37:40 Trigger before insert
Previous Message Klint Gore 2004-11-25 07:08:30 Re: [PERFORM] HELP speed up my Postgres