| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Goldner | 2006-10-11 18:21:26 | Re: "Hanging Connection" blocks access to table (JBossMQ) |
| Previous Message | Dave Cramer | 2006-10-11 17:57:02 | Re: "Hanging Connection" blocks access to table (JBossMQ) |