Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres entering zombie state once a week in production evnvironment - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: Postgres entering zombie state once a week in production evnvironment
Date
Msg-id dcc563d10904141405k7d64ad1emc584765bc8ca3f39@mail.gmail.com
Whole thread Raw
In response to Re: Postgres entering zombie state once a week in production evnvironment  (Bryce Nesbitt <bryce2@obviously.com>)
List pgsql-sql
Tree view 
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 by date:

Previous
From: Bryce Nesbitt
Date:
Subject: Re: Postgres entering zombie state once a week in production evnvironment
Next
From: Bryce Nesbitt
Date:
Subject: Postgres process resident size does not drop after killing statement