From: samantha mahindrakar <sam.mahindrakar@gmail.com>
To: Erik Jones <erik@myemma.com>
Cc: Decibel! <decibel@decibel.org>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance with temporary table
Date: Wed, 9 Apr 2008 22:43:17 -0400
Message-ID: <f0c828c40804091943o4e110a2q7830a2fc66286576@mail.gmail.com> (raw)
In-Reply-To: <7B9D16CA-CD05-4F07-B35B-31734A91BECB@myemma.com>
References: <f0c828c40804071127u512a5f89ka7866a148e3c7c21@mail.gmail.com>
<20080408161745.GB9062@alvh.no-ip.org>
<f0c828c40804081228x6e1edf2l881fe0725f1a5504@mail.gmail.com>
<20080408194310.GP9062@alvh.no-ip.org>
<83F6D568-0641-42CD-8A8D-845119CB3BA1@decibel.org>
<f0c828c40804091641w36b98fb9o7a4019f576d53ec6@mail.gmail.com>
<7B9D16CA-CD05-4F07-B35B-31734A91BECB@myemma.com>
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 <erik@myemma.com> 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
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sam.mahindrakar@gmail.com, erik@myemma.com, decibel@decibel.org, alvherre@commandprompt.com
Subject: Re: Performance with temporary table
In-Reply-To: <f0c828c40804091943o4e110a2q7830a2fc66286576@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox