Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id E59542E0033 for ; Tue, 8 Apr 2008 12:50:59 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 55748-06 for ; Tue, 8 Apr 2008 12:50:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pih-relay04.plus.net (pih-relay04.plus.net [212.159.14.131]) by developer.postgresql.org (Postfix) with ESMTP id A0BE52E002C for ; Tue, 8 Apr 2008 12:50:50 -0300 (ADT) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay04.plus.net with esmtp (Exim) id 1JjG5t-0004bH-Me; Tue, 08 Apr 2008 16:50:45 +0100 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 55BB0274074; Tue, 8 Apr 2008 16:50:42 +0100 (BST) Message-ID: <47FB9453.9070009@archonet.com> Date: Tue, 08 Apr 2008 16:50:43 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.12 (X11/20080213) MIME-Version: 1.0 To: samantha mahindrakar CC: pgsql-performance@postgresql.org Subject: Re: Performance with temporary table References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 319e1f1a4cbe491da2e5caa31cef18cb X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/91 X-Sequence-Number: 29584 samantha mahindrakar wrote: > Iam using a temporary table where in i put data from other partitoined > table. I then query this table to get the desired data.But the thing > is this temporary table has to be craeted for every record that i need > to correct and there are thousands of such records that need to be > corrected. > So the program necessarily creates a temporary table evrytime it has > to correct a record. However this table is dropeed after each record > is corrected. Why? -- Richard Huxton Archonet Ltd