Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-sql by date:

Previous
From: Steve Midgley
Date:
Subject: Re: changing multiple pk's in one update
Next
From: Scott Marlowe
Date:
Subject: Re: Postgres entering zombie state once a week in production evnvironment