Re: [PERFORM] HELP speed up my Postgres

From: "Iain" <iain(at)mst(dot)co(dot)jp>
To: <jerome(at)gmanmi(dot)tv>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: [PERFORM] HELP speed up my Postgres
Date: 2004-11-25 06:40:57
Message-ID: 002001c4d2b9$bba0b230$7201a8c0@mst1x5r347kymb
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)

Could you try using UPDATE ... FROM (SELECT ....) AS .. style syntax?

About 20 minutes ago, I changed a 8 minute update to an most instant by
doing that.

regards
Iain

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ElayaRaja S 2004-11-25 06:41:08 Help!
Previous Message JM 2004-11-25 06:29:48 Re: [PERFORM] HELP speed up my Postgres

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-11-25 06:55:25 Re: [PERFORM] HELP speed up my Postgres
Previous Message JM 2004-11-25 06:29:48 Re: [PERFORM] HELP speed up my Postgres