Re: Disk buffering of resultsets - Mailing list pgsql-jdbc

From Vitalii Tymchyshyn
Subject Re: Disk buffering of resultsets
Date
Msg-id CABWW-d0bNau=Ypx2iidbmMeuA8ks75xn=dNv7n4m_XEHz8wJkg@mail.gmail.com
Whole thread Raw
In response to Re: Disk buffering of resultsets  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: Disk buffering of resultsets  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-jdbc
Hello, all

I've made a draft implementation of setFetchSize in autocommit mode here: https://github.com/tivv/pgjdbc/tree/autocommit_fetchsize
Tests look good.
Note that it does not try to limit Execute size as I don't think I understand protocol fully. The only thing it does is that it does not read everything before returning to the caller. Instead it reads response rows in fetchSize batches. If another statement tries to use the same connection, full result is read immediatelly (this part is not tested yet).

Best regards, Vitalii Tymchyshyn

pgsql-jdbc by date:

Previous
From: Vitalii Tymchyshyn
Date:
Subject: Re: Disk buffering of resultsets
Next
From: Craig Ringer
Date:
Subject: Re: Disk buffering of resultsets