Re: Odd new symptom - database locking up on a query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Doug Fields <dfields-pg-general(at)pexicom(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Odd new symptom - database locking up on a query
Date: 2002-07-07 04:12:47
Message-ID: 6349.1026015167@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Doug Fields <dfields-pg-general(at)pexicom(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Jore 2002-07-07 04:38:28 Re: database backup
Previous Message Tom Lane 2002-07-07 03:56:42 Re: (A) native Windows port