Skip site navigation (1) Skip section navigation (2)

Re: [PERFORM] HELP speed up my Postgres

From: Jerome Macaranas <jerome(at)gmanmi(dot)tv>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [PERFORM] HELP speed up my Postgres
Date: 2004-11-26 08:28:31
Message-ID: 200411261628.31249.jerome@gmanmi.tv (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
it did..  thanks.. generally a weeks process turned out to be less than a 
day..



On Thursday 25 November 2004 15:06, Christopher Kings-Lynne wrote:
> > 		update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where mobile_num in (select
> > mobile_num from LOADED_MOBILE_NUMBERS)
>
> Change to:
>
> update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where exists (select 1 from
> LOADED_MOBILE_NUMBERS lmn where
> lmn.mobile_num=SUBSCRIPTIONTABLE.mobile_num);
>
> That should run a lot faster.
>
> Make sure you have indexes on both mobile_num columns.
>
> Chris
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html


-- 

Jerome Macaranas
Systems/Network Administrator
GMA New Media, Inc.
Phone: (632) 9254627 loc 202
Fax: (632) 9284553
Mobile: (632) 918-9336819
jerome(at)gmanmi(dot)tv

Sanity is the playground for the unimaginative.


DISCLAIMER: This Message may contain confidential information intended only 
for the use of the addressee named above. If you are not the intended 
recipient of this message you are hereby notified that any use, 
dissemination, distribution or reproduction of this message is prohibited. If 
you received this message in error please notify your Mail Administrator and 
delete this message immediately. Any views expressed in this message are 
those of the individual sender and may not necessarily reflect the views of 
GMA New Media, Inc.


In response to

pgsql-performance by date

Next:From: Richard HuxtonDate: 2004-11-26 09:12:15
Subject: Re: Postgres backend using huge amounts of ram
Previous:From: Neil ConwayDate: 2004-11-26 03:25:25
Subject: Re: Postgres vs. DSpam

pgsql-general by date

Next:From: Arjen van der MeijdenDate: 2004-11-26 08:42:59
Subject: Re: PostgreSQL slow after VACUUM
Previous:From: gnariDate: 2004-11-26 08:24:39
Subject: Re: PostgreSQL slow after VACUUM

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group