Tom Lane wrote:
> Michael Goldner <mgoldner(at)agmednet(dot)com> writes:
>> When I shutdown Jboss, the idle process disappears, but the 2 "INSERT
>> waiting" processes remain indefinitely.
> Ah. That makes sense, because a backend blocked partway through a query
> isn't going to notice its client disconnecting. The question here
> though is still "what are they waiting for?". See pg_locks.
Is there any possibility that we make a backend realize this SIGIO (or
whatever it gets) when the connection is closed? I often had the problem
that I shut down my application, but the server kept working on that
query for a long time.
The same is for very long running C-Code functions (like PostGIS
geomUnion() on geometries with millions of vertices), those also tend to
block the backend for long times, without any possibility to kill it
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
In response to
pgsql-jdbc by date
|Next:||From: zhyu 86||Date: 2006-10-13 14:09:36|
|Subject: Re: MBC user cannot connect to server|
|Previous:||From: Dave Cramer||Date: 2006-10-13 10:35:29|
|Subject: Re: Retrieving arrays|