Re: Insertion to temp table deteriorating over time

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Insertion to temp table deteriorating over time
Дата
Msg-id 19298.1166464855@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Insertion to temp table deteriorating over time  ("Steven Flatt" <steven.flatt@gmail.com>)
Ответы Re: Insertion to temp table deteriorating over time  ("Steven Flatt" <steven.flatt@gmail.com>)
Список pgsql-performance
"Steven Flatt" <steven.flatt@gmail.com> writes:
> I can fix this problem by using CREATE TEMP TABLE ... LIKE instead of CREATE
> TEMP TABLE ... AS.

That seems ... um ... bizarre.  Now are you able to put together a
self-contained test case?  Seems like we could have two independent bugs
here: first, why (and how) is the temp table different, and second how
does that result in the observed performance problem.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Steven Flatt"
Дата:
Сообщение: Re: Insertion to temp table deteriorating over time
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Advice on selecting good values for work_mem?