Postgres Pro
Downloads
Home   >   mailing lists

Re: Odd new symptom - database locking up on a query - Mailing list pgsql-general

From Tom Lane
Subject Re: Odd new symptom - database locking up on a query
Date
Msg-id 6349.1026015167@sss.pgh.pa.us
Whole thread Raw
In response to Odd new symptom - database locking up on a query  (Doug Fields <dfields-pg-general@pexicom.com>)
Responses Re: Odd new symptom - database locking up on a query  (Doug Fields <dfields-pg-general@pexicom.com>)
List pgsql-general
Tree view 
Doug Fields <dfields-pg-general@pexicom.com> writes:
> At a certain point, a query hangs, then another, then another, until all my
> connections are blocked. My application completely comes to a halt.

Are they actually hung, or just taking an unreasonable amount of time?

Can you attach to some of the busy backends with gdb and get stack
traces?

            regards, tom lane

pgsql-general by date:

Previous
From: Doug Fields
Date:
Subject: Re2: Odd new symptom - database locking up on a query
Next
From: Josh Jore
Date:
Subject: Re: database backup