On 09.06.2005 02:06 Tom Lane wrote:
> Thomas Kellerer <[EMAIL PROTECTED]> writes:
>
>>Is there anything I can do, to convince PG to return the first row more
>>quickly?
>
>
> libpq's API for PQresult is such that it really doesn't have any choice
> but to collect the full result set before it hands you back the
> PQresult. I don't know JDBC very well but I think it has similar
> semantic constraints.
>
> The solution is to use a cursor and FETCH a reasonably small number of
> rows at a time.
>
My understanding was that setting the fetchSize() to 1 in JDBC would force the
use of a cursor.
I'll have to go through the JDBC docs again to check how I can enforce this.
Thanks for the answer though
Thomas
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
