On Sun, Nov 02, 2003 at 08:50:54AM +0100, Christer Sundgren wrote:
> It takes 14 times longer time to get data from a large log table with a
> JDBC connection compared to libpq. Is there a way to increase the speed
> with the pg73jdbc3 driver?
[...]
> The total time to fetch 52000 records is 1218 seconds with the pg73jdbc3
> driver and 1180 seconds with the pgjdbc2.
Quite a lot of this can be JVM tuning. What JVM are you running, exactly? If
it's a Sun JVM, is it the client or server JVM? What heap settings are you
using? Are they approprate for the amount of data you're retrieving (how
large is each row)? Try running with -verbose:gc and see how much time is
spent in GC.
There was a similar question a while back where the dominant cost was GC ..
the default JVM heap settings aren't too good for large data sets.
-O