client interfaces

"David Parker" <dparker@tazznetworks.com> writes:

Is there anything like a client library for postgres that does not use
tcp/ip as the protocol?

Local connections generally go through Unix sockets, which is not the
tcp stack.

regards, tom lane

On Tue, Apr 12, 2005 at 10:51:09AM -0400, David Parker wrote:

Is there anything like a client library for postgres that does not use
tcp/ip as the protocol? As part of the performance tuning of our
application, the question was posed to me whether there was a more
"direct" sort of API that would not require going through the tcp/ip
stack. I assume the answer to this is "no", and I see no hint of
anything in the source code, but I thought I would ask the question,
just to be sure.

PostgreSQL supports connections over Unix-domain (AF_UNIX) sockets
if your system does. They still use the socket interface, but
they're typically faster than a TCP connection.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

On Tue, Apr 12, 2005 at 10:51:09 -0400,
David Parker <dparker@tazznetworks.com> wrote:

Is there anything like a client library for postgres that does not use
tcp/ip as the protocol? As part of the performance tuning of our
application, the question was posed to me whether there was a more
"direct" sort of API that would not require going through the tcp/ip
stack. I assume the answer to this is "no", and I see no hint of
anything in the source code, but I thought I would ask the question,
just to be sure.

You can use domain sockets when on the same host as the server.