Re: Cheapest way to poll for notifications? & Driver improvement question re SSL and notify - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Cheapest way to poll for notifications? & Driver improvement question re SSL and notify
Date
Msg-id 4B2EEBF2.7030708@opencloud.com
Whole thread Raw
In response to Cheapest way to poll for notifications? & Driver improvement question re SSL and notify  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: Cheapest way to poll for notifications? & Driver improvement question re SSL and notify
List pgsql-jdbc
Craig Ringer wrote:

> === Why can't JDBC/SSL just test for data ready to read, anyway? ===

Yeah, the SSL interface does suck :(

I am wondering if we should look at a dedicated read thread per
connection. In the past I avoided this because it doesn't scale to large
numbers of connections, and there may be some overhead from context
switching on I/O (though I haven't measured this). But between issues
with notifications+SSL, and the increasing number of reports of I/O
deadlocks, maybe we should look at it again.

-O

pgsql-jdbc by date:

Previous
From: John R Pierce
Date:
Subject: Re: keeping Connection alive
Next
From: Fred Janon
Date:
Subject: Issue with the JDBC driver doing timezone conversions on "java.sql.Date"?