Skip site navigation (1) Skip section navigation (2)

Re: "Hanging Connection" blocks access to table (JBossMQ)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Goldner <mike(dot)goldner(at)comcast(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: "Hanging Connection" blocks access to table (JBossMQ)
Date: 2006-10-11 18:13:18
Message-ID: 27572.1160590398@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
Michael Goldner <mike(dot)goldner(at)comcast(dot)net> writes:
> Could autovacuum be using enough memory so that postgres cannot handle
> the insert of the large row?

No.  You might be having locking problems, though --- have you looked
into pg_locks to see if anything is blocked on a lock?  Those "INSERT
waiting" processes certainly look like they are so blocked.

There was a thread just yesterday
http://archives.postgresql.org/pgsql-performance/2006-10/msg00190.php
suggesting that 8.1's autovacuum might have some as-yet-undetermined
locking issues, but that's only speculation at this point.  If you can
get some evidence showing that it's really happening, I'm all ears...

			regards, tom lane

In response to

pgsql-jdbc by date

Next:From: Michael GoldnerDate: 2006-10-11 18:21:26
Subject: Re: "Hanging Connection" blocks access to table (JBossMQ)
Previous:From: Dave CramerDate: 2006-10-11 17:57:02
Subject: Re: "Hanging Connection" blocks access to table (JBossMQ)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group