From: Clayton Vernon <cvernon@enron.com>
To: John Oakes <john@networkproductions.net>
To: Doug McNaught <doug@wireboard.com>
Cc: pgsql-general@postgresql.org
Subject: Re: JDBC speed question.
Date: Thu, 26 Apr 2001 18:16:02 -0500
Message-ID: <00e801c0cea6$dc848820$5a2510ac@corp.enron.com> (raw)
References: <wCiF6.88303$fs3.14153563@typhoon.tampabay.rr.com>
<m3pudzuw5g.fsf@belphigor.mcnaught.org>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: cvernon@enron.com, john@networkproductions.net, doug@wireboard.com, pgsql-general@postgresql.org
Subject: Re: JDBC speed question.
In-Reply-To: <00e801c0cea6$dc848820$5a2510ac@corp.enron.com>
References: <wCiF6.88303$fs3.14153563@typhoon.tampabay.rr.com> <m3pudzuw5g.fsf@belphigor.mcnaught.org> <00e801c0cea6$dc848820$5a2510ac@corp.enron.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox