Re: Major Performance decrease after some hours

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Major Performance decrease after some hours
Дата
Msg-id 26610.1159756994@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Major Performance decrease after some hours  ("Peter Bauer" <peter.m.bauer@gmail.com>)
Ответы Re: Major Performance decrease after some hours  ("Peter Bauer" <peter.m.bauer@gmail.com>)
Список pgsql-general
"Peter Bauer" <peter.m.bauer@gmail.com> writes:
> Attached you can find the postgresql logfiles and a logfile which
> contains alls SQL statements executed in the relevant time together
> with the excpetions thrown. I also attached a file with all used
> Pl/pgSQL functions. Since we were not able to find a problem for so
> long, i think it makes no sense to filter the information because we
> are probably not looking on the right spots.

I hope the pgsql-general moderators are not going to approve an 8MB
message :-(.  I'll hang onto my copy though, just in case it proves
useful.

>> It might be worth attaching to a few of them with
>> gdb to get stack traces,

> Should this be done when the problems are appearing or during normal
> operation or both to compare the results?

When the problems are appearing.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Normal vs Surrogate Primary Keys...
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Normal vs Surrogate Primary Keys...