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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Bryce Nesbitt <bryce2(at)obviously(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Postgres entering zombie state once a week in production evnvironment
Date: 2009-04-14 21:05:41
Message-ID: dcc563d10904141405k7d64ad1emc584765bc8ca3f39@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Apr 14, 2009 at 2:59 PM, Bryce Nesbitt <bryce2(at)obviously(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bryce Nesbitt 2009-04-15 03:46:58 Postgres process resident size does not drop after killing statement
Previous Message Bryce Nesbitt 2009-04-14 20:59:28 Re: Postgres entering zombie state once a week in production evnvironment