Re: Cheapest way to poll for notifications? & Driver improvement question re SSL and notify

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: PG-JDBC Mailing List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Cheapest way to poll for notifications? & Driver improvement question re SSL and notify
Date: 2009-12-21 03:30:58
Message-ID: 4B2EEBF2.7030708@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-12-21 03:39:00 Re: PL/Perl Performance Problems
Previous Message Alex - 2009-12-21 03:28:36 Re: PL/Perl Performance Problems

Browse pgsql-jdbc by date

  From Date Subject
Next Message Fred Janon 2009-12-21 06:51:06 Issue with the JDBC driver doing timezone conversions on "java.sql.Date"?
Previous Message John R Pierce 2009-12-21 03:25:43 Re: keeping Connection alive