Posgres conf

[Jacques Le Roux]

Hi devs,

Should we not put "result-fetch-size="50"" as default and slightly change the comment for older versions ?

Jacques

[Divesh Dutta]

Hi Jacques,

Is there any reason for setting default fetch-size = 50, because
application is using  queries by iterator and that can be benefited from
fetch size=10 also. I don't know much about this. It would be great  if
you share this with me.

Thanks
--
Divesh


Jacques Le Roux wrote:
> Hi devs,
>
> Should we not put "result-fetch-size="50"" as default and slightly
> change the comment for older versions ?
>
> Jacques
>

[Ashish Vijaywargiya]

Is it right subject for this email?
Confused what you are referring Jacuqes.

--
Ashish

On Wed, Jun 10, 2009 at 6:26 PM, Jacques Le Roux <
[hidden email]> wrote:

> Hi devs,
>
> Should we not put "result-fetch-size="50"" as default and slightly change
> the comment for older versions ?
>
> Jacques
>
>

[Jacques Le Roux]

Yes, to be clear it's about entityengine.xml, sorry.

Jacques

From: "Ashish Vijaywargiya" <[hidden email]>

> Is it right subject for this email?
> Confused what you are referring Jacuqes.
>
> --
> Ashish
>
> On Wed, Jun 10, 2009 at 6:26 PM, Jacques Le Roux <
> [hidden email]> wrote:
>
>> Hi devs,
>>
>> Should we not put "result-fetch-size="50"" as default and slightly change
>> the comment for older versions ?
>>
>> Jacques
>>
>>
>

[Jacques Le Roux]

Hi Divesh,

I did not dig this subject profoundly. I only saw this comment in entityengine.xml
<!-- use this attribute to make the EntityListIterator more effective for pgjdbc 7.5devel and later:
result-fetch-size="50"
-->

And, as I guess, less and less people use postgres versions before 7.5 I suggested this change, that's all

Jacques

From: "Divesh Dutta" <[hidden email]>

> Hi Jacques,
>
> Is there any reason for setting default fetch-size = 50, because
> application is using  queries by iterator and that can be benefited from
> fetch size=10 also. I don't know much about this. It would be great  if
> you share this with me.
>
> Thanks
> --
> Divesh
>
>
> Jacques Le Roux wrote:
>> Hi devs,
>>
>> Should we not put "result-fetch-size="50"" as default and slightly
>> change the comment for older versions ?
>>
>> Jacques
>>
>

[Ashish Vijaywargiya]

+1 for this change.
IMO only few of the guys are using 7.5 and the proportion will be around 5
out of 50.

I had read information on the postgres website to use Postgres 8.x versions.

They are promoting it and keeping it as the lot stable release from all the
predecessor ones.

--
Ashish

On Thu, Jun 11, 2009 at 7:46 PM, Jacques Le Roux <
[hidden email]> wrote:

> Hi Divesh,
>
> I did not dig this subject profoundly. I only saw this comment in
> entityengine.xml
> <!-- use this attribute to make the EntityListIterator more effective for
> pgjdbc 7.5devel and later:
> result-fetch-size="50"
> -->
>
> And, as I guess, less and less people use postgres versions before 7.5 I
> suggested this change, that's all
>
> Jacques
>
>