Re: Postgres entering zombie state once a week in production evnvironment

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Postgres entering zombie state once a week in production evnvironment
Дата
Msg-id dcc563d10904141405k7d64ad1emc584765bc8ca3f39@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres entering zombie state once a week in production evnvironment  (Bryce Nesbitt <bryce2@obviously.com>)
Список pgsql-sql
Дерево обсуждения 
On Tue, Apr 14, 2009 at 2:59 PM, Bryce Nesbitt <bryce2@obviously.com> wrote:
> Scott Marlowe wrote:
>>
>> What does pg_locks say during this time?  Specifically about locks
>> that aren't granted?
>
> I don't know, yet.  Though these events go for 15-30 minutes before postgres
> restart, and no deadlocks are detected, so I don't think it is locks.

Ummm, deadlocks <> locks blocking other queries.

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

Предыдущее
От: Bryce Nesbitt
Дата:
Сообщение: Re: Postgres entering zombie state once a week in production evnvironment
Следующее
От: Bryce Nesbitt
Дата:
Сообщение: Postgres process resident size does not drop after killing statement