Re: Postgres 8.2 and setFetchSize

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Frédéric Houbie <fh(at)ionicsoft(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Postgres 8.2 and setFetchSize
Date: 2007-09-19 14:17:33
Message-ID: 46F12F7D.3000908@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Frédéric Houbie wrote:
> I know, two differents tests on two databases, I know also that setFetchSize limit the number of rows that are returned without waiting the full result list. That's what I want. The fact is that the behaviour is different from my pc (windows XP, pg 8.2.4).

What does the other database (the one that is slow) log for the same
case as this one, then?

>> 2007-09-19 14:10:51.993 LOG: duration: 0.000 ms execute S_2/C_3: SELECT * FROM SValues

-O

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2007-09-20 02:46:55 Re: Batch INSERT failing with error 22P02
Previous Message Frédéric Houbie 2007-09-19 13:54:13 Re: Postgres 8.2 and setFetchSize