View Single Post

   
  #8 (permalink)  
Old 04-16-2008, 01:00 AM
Toru SHIMOGAKI
 
Posts: n/a
Default Re: Patch to add a socketTimeout property.

2008/4/11, Kris Jurka <books@ejurka.com>:

> I don't see a danger with exposing them as options as long as the pros and
> cons are clearly explained.


How about the following list to compare keepalive and socket timeout?
Please add other topics, if any.


keepalive socket timeout
------------------------------------------------------------------
Configurability No in Java Yes
(depend on OS setting)

Target All connections Each connection

Standard timer 2 hours Depend on users
setting

Influence All of applications Long running query
on a same OS using a same connection

Overhead Network for CPU for timer
keepalive proves



On the other hand, should we provide the both properties and users
chose either of them depend on their requirement?

--
Toru SHIMOGAKI <shimogaki.toru@gmail.com>

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

Reply With Quote