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.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
