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

Re: NIO support

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Віталій Тимчишин <tivv00(at)gmail(dot)com>
Cc: PG-JDBC Mailing List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: NIO support
Date: 2012-01-20 12:05:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Can you confirm that this patch is just to add time out ?

If not can you outline what problem you are trying to solve ?

Dave Cramer


2012/1/19 Віталій Тимчишин <tivv00(at)gmail(dot)com>:
> OK, I finally have first try of NIO support in the patch attached.
> The only current feature is query timeout without any additional threads.
> Please note that current driver has a bug: JDBC specs says timeout is in
> seconds and driver takes it as millis, fixed in my patch.
> Also current query timeout schema limitation is that query timeout
> processing still requires server round trips that are not under timeout
> control. I really don't see how much this differ from simply setting
> server-side timeout for fast connections. For slow connections it's still
> unreliable. Good thing that it is may be possible to enforce some kind of
> hard timeout with NIO schema as it's easy to control blocking calls.
> Limitations: only for V3 non-secure connections. Other connections use
> regular stream-based implementation.
> Planned features:
>  * SSL with NIO. This should allow to receive notifications without server
> roundtrip in SSL mode
>  * Read answer while sending query. This should make go away the problem
> when large query is blocked because answer must be read to send more data to
> server.
> Note that I have never worked with CVS and have problems to make patch with
> new files (AFAICS I can't add it to CVS with RO access).
> Comments are welcome.
> P.S. To work with SSL I need to start SSL tests. Any hints?
> --
> Best regards,
>  Vitalii Tymchyshyn
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:

In response to

  • NIO support at 2012-01-19 23:15:34 from Віталій Тимчишин


pgsql-jdbc by date

Next:From: Роман ЛитовченкоDate: 2012-01-20 13:05:38
Subject: Re: plpgsql function, comment with single quote, braces
Previous:From: Florent GuillaumeDate: 2012-01-20 10:10:31
Subject: Re: plpgsql function, comment with single quote, braces

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