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

From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Dave Cramer
>       ​defaultRowFetchSize is not an internal number.​ If you set the
> property you get the value of the property.
>
>
>
>
> That I agree with. If you don't set it you get 0

You will get the value of defaultRowFetchSize if you don't call setFetchSize(), and the default value of defaultRowFetchSize will be, say, 100.  As I mentioned in the previous mail, I think getFetchSize() returns the actual number of rows, not the hint (0).

Any comments on the default value of defaultRowFetchSize?  There was a request for 1,000.  I think 100 would be sufficient, considering the typical web pagination, for example.  Those who want to speed up batch apps by reducing round trips can find the parameter and/or setFetchSize() and use them.