Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-jdbc by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group