Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 801CE2E003D for ; Wed, 9 Apr 2008 23:43:22 -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 21066-10 for ; Wed, 9 Apr 2008 23:43:19 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.176]) by developer.postgresql.org (Postfix) with ESMTP id 4FC952E002C for ; Wed, 9 Apr 2008 23:43:19 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id n7so2129wag.5 for ; Wed, 09 Apr 2008 19:43:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=oAHKazaMhJxWKUVk0YgxdZsiDdQKwUxpo5iNuZpfCPQ=; b=kja4tadVSwteqn2gGfpxOWLJPW6mI+Lp9fUFxq9qkXRLlUsmyu+W7zKAzR4QKjlLdWICPEsCUAXGNGBmHzt8AfJPeb8o6f4LTrAYuFxeuBlJyEClWH5qAlbxI65lOP0xPGLE6+QYJp6ihmGnJ4VFd4CX9HP0/NuDb0F9dK5K7rU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Uot62jvaStkxh7dSomQidafminU4kND3Dd/pgpyzeMZ7grf8f90W3ABy4gwCEA7XiRQ6YAP9Gq7ETytBom8PKTp8+9k7X+LDA6FA15hKosctGoOAwA8wbBPSaVZYWocboPsIheT+P0Ba6uUfF8TSiPtoo4hoS5qvVOZPyF3cK6A= Received: by 10.114.127.1 with SMTP id z1mr1183546wac.26.1207795397818; Wed, 09 Apr 2008 19:43:17 -0700 (PDT) Received: by 10.114.181.19 with HTTP; Wed, 9 Apr 2008 19:43:17 -0700 (PDT) Message-ID: Date: Wed, 9 Apr 2008 22:43:17 -0400 From: "samantha mahindrakar" To: "Erik Jones" Subject: Re: Performance with temporary table Cc: Decibel! , "Alvaro Herrera" , pgsql-performance@postgresql.org In-Reply-To: <7B9D16CA-CD05-4F07-B35B-31734A91BECB@myemma.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20080408161745.GB9062@alvh.no-ip.org> <20080408194310.GP9062@alvh.no-ip.org> <83F6D568-0641-42CD-8A8D-845119CB3BA1@decibel.org> <7B9D16CA-CD05-4F07-B35B-31734A91BECB@myemma.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/121 X-Sequence-Number: 29614 We store traffic data in the partitioned tables. But the problem is that all this data is not correct. The data is corrupt, hence they need to be corrected. On Wed, Apr 9, 2008 at 10:31 PM, Erik Jones wrote: > > On Apr 9, 2008, at 6:41 PM, samantha mahindrakar wrote: > > > Hi > > The reason for using the temporary table is that i need this data > > buffered somewhere so that i can use it for later computation. And the > > fact that for each imputation i need to have historical data from 10 > > previous weeks makes it necessary to create something that can hold > > the data. However once the computation is done for each record i > > wouldn't need that historical data for that record. I Would be moving > > on to the next record and find its own historical data. > > Is there any way i can avoid using temp table? > > > > What's wrong with the data in the paritions? > > Erik Jones > > DBA | Emma(R) > erik@myemma.com > 800.595.4401 or 615.292.5888 > 615.292.0777 (fax) > > Emma helps organizations everywhere communicate & market in style. > Visit us online at http://www.myemma.com > > > >