Re: [RFC] How about changing the default value of defaultRowFetchSize?

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Vitalii Tymchyshyn <vit(at)tym(dot)im>
Cc: "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>, Jorge Solorzano <jorsol(at)gmail(dot)com>, Mark Rotteveel <mark(at)lawinegevaar(dot)nl>, List <pgsql-jdbc(at)postgresql(dot)org>, Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
Subject: Re: [RFC] How about changing the default value of defaultRowFetchSize?
Date: 2016-10-23 11:39:58
Message-ID: CADK3HHKEqqFRPT5PEP682JFV0M=h1OVf4VY6X711QcdgDzuTFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

The only thing I disagree with is returning the internal number. 0 means it
has not been set.

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

On 21 October 2016 at 08:12, Vitalii Tymchyshyn <vit(at)tym(dot)im> wrote:

> How in this case one would enable previous behavior (fetching all)?
>
> Also as for me, 100 is too low. I'd make it 1000 and make configurable
> from the uri (defaultFetchSize).
>
> Best regards, Vitalii Tymchyshyn
>
> Пт, 21 жовт. 2016 00:34 користувач Tsunakawa, Takayuki <
> tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> пише:
>
>> From: pgsql-jdbc-owner(at)postgresql(dot)org
>> > [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Tsunakawa,
>> Takayuki
>> > * When setFetchSize() is not called, or setFetchSize(0) was called
>> > getFetchSize() returns 100.
>> > The actual number of rows fetched is 100.
>>
>> Sorry, not 100, but the value of defaultRowFetchSize.
>>
>> Regards
>> Takayuki Tsunakawa
>>
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Vitalii Tymchyshyn 2016-10-23 13:50:03 Re: question regarding connection failover URL postgresql 9.6 (master/slave)
Previous Message martin zoldano 2016-10-21 23:27:47 question regarding connection failover URL postgresql 9.6 (master/slave)