Re: Backends dying due to memory exhaustion--I'm stonkered

Поиск
Список
Период
Сортировка
От carl garland
Тема Re: Backends dying due to memory exhaustion--I'm stonkered
Дата
Msg-id F11dZjfNLnlyg35sQtg00000903@hotmail.com
обсуждение исходный текст
Ответ на Backends dying due to memory exhaustion--I'm stonkered  (Doug McNaught <doug@wireboard.com>)
Список pgsql-general
>
>Waiting for the next crash with anticipation...

Since you said you are running ACS is here you may as well want to
set the param Verbose to True in your db pool which will log all queries to
the db in the access log.  Then when it crashes during
normal execution you can simple determine the offending query.  Of
course this may create a copius log file on an heavily accessed site and you
may wish to roll the log more freqently. Also wont may not
be related or help the vacuum situation.

Best Regards,
Carl Garland
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com


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

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Re: Wild Cards
Следующее
От: Marc SCHAEFER
Дата:
Сообщение: Search engine doesn't work