Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: Andrea Spinelli <aspinelli(at)imteam(dot)it>, pgsql-jdbc(at)postgresql(dot)org, Alessandro Magnolo <amagnolo(at)imteam(dot)it>, Valerio Mazzoleni <vmazzoleni(at)imteam(dot)it>
Subject: Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter
Date: 2007-08-10 16:14:54
Message-ID: 3763.1186762494@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Kris Jurka <books(at)ejurka(dot)com> writes:
> People want the query to be stopped, but they don't want their whole
> connection to be killed which is what your change does.

Can't you just "set statement_timeout = something" if you don't want to
let long queries complete?

regards, tom lane

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2007-08-10 16:20:45 Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter
Previous Message Oliver Elphick 2007-08-10 16:12:01 Re: [NOVICE] Install two different versions of postgres which should run in parallel