Re: JDBC speed question.

Related question: how do you run postgreSQL to simultaneously support a Unix
socket and TCP/IP?

----- Original Message -----
From: "Doug McNaught" <doug@wireboard.com>
To: "John Oakes" <john@networkproductions.net>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, April 26, 2001 5:35 PM
Subject: Re: [GENERAL] JDBC speed question.


> "John Oakes" <john@networkproductions.net> writes:
>
> > Anyone have any ideas how to speed up performance using the JDBC driver?
A
> > query that takes me 20 seconds to execute from command line takes 1 full
> > minute with the jdbc driver.  Thanks.
>
> Since you don't guve any details of your query or network setup, it's
> hard to help much.  What could account for the difference, assuming
> that the query is exactly the same in both cases, is that the JDBC
> driver connects through TCP/IP (even when on the same host) whereas
> 'psql' will by default connect through a Unix socket.  On most
> systems, Unix sockets are considerably faster than even local TCP
> sockets.  If the JDBC client is running on a different machine, the
> difference becomes even more pronounced.
>
> This is assuming that your query is returning a great deal of data, so
> the network pipe is a factor in the execution time.  If it isn't, then
> it's unclear how to help you without more details on your table
> layouts and the query itself.
>
> -Doug
> --
> The rain man gave me two cures; he said jump right in,
> The first was Texas medicine--the second was just railroad gin,
> And like a fool I mixed them, and it strangled up my mind,
> Now people just get uglier, and I got no sense of time...          --Dylan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>