Re: Insertion to temp table deteriorating over time

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Insertion to temp table deteriorating over time
Дата
Msg-id 20792.1166211026@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've been trying to reproduce the problem for days now :).  I've done pretty
> much exactly what you describe below, but I can't reproduce the problem on
> any of our lab machines.  Something is indeed special in this environment.

Yuck.  You could try strace'ing the problem backend and see if anything
is visibly different between fast and slow operation.  I don't suppose
you have oprofile on that machine, but if you did it'd be even better.

            regards, tom lane

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

Предыдущее
От: "Steven Flatt"
Дата:
Сообщение: Re: Insertion to temp table deteriorating over time
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: File Systems Compared