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 43CA73A464A for ; Thu, 25 Nov 2004 09:21:20 +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 73970-07 for ; Thu, 25 Nov 2004 09:21:10 +0000 (GMT) Received: from mx1.mail.ru (mx1.mail.ru [194.67.23.121]) by svr1.postgresql.org (Postfix) with ESMTP id 9939A3A4635 for ; Thu, 25 Nov 2004 09:21:10 +0000 (GMT) Received: from [62.133.163.106] (port=3917 helo=ws5) by mx1.mail.ru with asmtp id 1CXFoK-000J6Q-00; Thu, 25 Nov 2004 12:21:08 +0300 Message-ID: <077301c4d2d0$1608ea10$191716ac@ws5> From: "Anatoly Okishev" To: Cc: "pgsql-general" References: <200411251400.32752.jerome@gmanmi.tv> Subject: Re: HELP speed up my Postgres Date: Thu, 25 Nov 2004 14:21:00 +0500 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Spam: Not detected X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.0 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS, UPPERCASE_50_75 X-Spam-Level: ** X-Archive-Number: 200411/1257 X-Sequence-Number: 69337 > 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.