Re: SELECT very slow

> If autocommit is on (or fetch size is zero) then the driver will build  
> the whole
> result set before returning to the caller.
Sure, but that is not your problem : even building the whole result set  
should not take longer than a few seconds (I gave you test timings in a  
previous message).So... what ?What does the taskman say ? CPU at 100% ? how much kernel time ?

>
> http://jdbc.postgresql.org/documentation/80/query.html#query-with-cursor
>
> Thomas
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>