Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] HELP speed up my Postgres - Mailing list pgsql-general

From Iain
Subject Re: [PERFORM] HELP speed up my Postgres
Date
Msg-id 002001c4d2b9$bba0b230$7201a8c0@mst1x5r347kymb
Whole thread Raw
In response to HELP speed up my Postgres  (JM <jerome@gmanmi.tv>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: JM
Date:
Subject: Re: [PERFORM] HELP speed up my Postgres
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] HELP speed up my Postgres