Re: Performance with temporary table

From: Richard Huxton <dev(at)archonet(dot)com>
To: samantha mahindrakar <sam(dot)mahindrakar(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance with temporary table
Date: 2008-04-08 15:50:43
Message-ID: 47FB9453.9070009@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2008-04-08 16:17:45 Re: Performance with temporary table
Previous Message Matthew 2008-04-08 14:00:13 Re: bulk insert performance problem