Unix domain instead of TCP socket connections with JDBC.

From: froggle2003(at)yahoo(dot)com (Alex Martinoff)
To: pgsql-general(at)postgresql(dot)org
Subject: Unix domain instead of TCP socket connections with JDBC.
Date: 2003-09-07 19:20:14
Message-ID: 34f50f10.0309071120.379706a3@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Using the org.postgresql.Driver JDBC driver is it possible to connect
to Postgres using a unix domain socket instead of a TCP socket (so you
don't have to start the postmaster with -i)? Using a TCP socket
instead of a unix socket seems to slow down requests that return large
result sets by a factor of 3 on the same machine. What's the point of
all the extra CPU overhead if you're on the same machine? A
high-volume server can really do without the extra overhead. Also, for
security reasons it would be slightly nicer to run Postgres without -i
just so there's one less port popping up when you port-scan.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Holger Marzen 2003-09-07 19:24:36 Re: Does "vacuum analyze" contain "vacuum"?
Previous Message Larry Rosenman 2003-09-07 19:18:59 Re: Unixware 713 probs