Re: Proposal: RETURNING primary_key() - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: Proposal: RETURNING primary_key()
Date
Msg-id CAMsr+YHRW=GFW-MSDbVBN8XMiXhAdZEK9WwEwxx_Ctr-2y3njg@mail.gmail.com
Whole thread Raw
In response to Re: Proposal: RETURNING primary_key()  ("Igal @ Lucee.org" <igal@lucee.org>)
Responses Re: Proposal: RETURNING primary_key()
List pgsql-hackers
On 10 March 2016 at 00:41, Igal @ Lucee.org <igal@lucee.org> wrote:
On 3/8/2016 5:12 PM, Craig Ringer wrote:
One of the worst problems (IMO) is in the driver architecture its self. It attempts to prevent blocking by guestimating the server's send buffer state and its recv buffer state, trying to stop them filling and causing the server to block on writes. It should just avoid blocking on its own send buffer, which it can control with confidence. Or use some of Java's rather good concurrency/threading features to simultaneously consume data from the receive buffer and write to the send buffer when needed, like pgjdbc-ng does.

Are there good reasons to use pgjdbc over pgjdbc-ng then?


Maturity, support for older versions (-ng just punts on support for anything except new releases) and older JDBC specs, completeness of support for some extensions. TBH I haven't done a ton with -ng yet.


--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Kouhei Kaigai
Date:
Subject: Re: Reworks of CustomScan serialization/deserialization
Next
From:
Date:
Subject: Re: [PROPOSAL] VACUUM Progress Checker.