Re: Performance with temporary table - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Performance with temporary table
Date
Msg-id 47FB9453.9070009@archonet.com
Whole thread Raw
In response to Performance with temporary table  ("samantha mahindrakar" <sam.mahindrakar@gmail.com>)
List 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

pgsql-performance by date:

Previous
From: Matthew
Date:
Subject: Re: bulk insert performance problem
Next
From: Alvaro Herrera
Date:
Subject: Re: Performance with temporary table