Re: Performance with temporary table

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Performance with temporary table
Дата
Msg-id 47FB9453.9070009@archonet.com
обсуждение исходный текст
Ответ на Performance with temporary table  ("samantha mahindrakar" <sam.mahindrakar@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Matthew
Дата:
Сообщение: Re: bulk insert performance problem
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Performance with temporary table