X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6B38E3A49E8 for ; Fri, 26 Nov 2004 08:28:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55596-01 for ; Fri, 26 Nov 2004 08:28:37 +0000 (GMT) Received: from gatekeeper.gmanetwork.com (mailhost.gmanetwork.com [61.9.4.50]) by svr1.postgresql.org (Postfix) with ESMTP id B86633A4902 for ; Fri, 26 Nov 2004 08:28:34 +0000 (GMT) Received: from gmanmi.tv (mailhost.gmanmi.tv [192.168.6.3]) by gatekeeper.gmanetwork.com (8.12.8/8.12.8) with ESMTP id iAQ8SWBV007462 for ; Fri, 26 Nov 2004 16:28:32 +0800 Received: (qmail 32145 invoked by uid 107); 26 Nov 2004 08:28:32 -0000 Received: from mail.gmanmi.tv (HELO jerome.gmanmi.tv) (192.168.6.3) by mail.gmanmi.tv with SMTP; 26 Nov 2004 08:28:32 -0000 From: Jerome Macaranas To: Christopher Kings-Lynne Subject: Re: [PERFORM] HELP speed up my Postgres Date: Fri, 26 Nov 2004 16:28:31 +0800 User-Agent: KMail/1.5.4 Cc: pgsql-performance@postgresql.org, pgsql-general@postgresql.org References: <200411251400.32752.jerome@gmanmi.tv> <41A58473.5020106@familyhealth.com.au> In-Reply-To: <41A58473.5020106@familyhealth.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200411261628.31249.jerome@gmanmi.tv> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=EXCUSE_16 X-Spam-Level: X-Archive-Number: 200411/1314 X-Sequence-Number: 69394 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@gmanmi.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.