Skip site navigation (1) Skip section navigation (2)

Re: Performance over a LAN

From: Rod Taylor <pg(at)rbt(dot)ca>
To: William Carney <wcarney(at)sa(dot)quiktrak(dot)com(dot)au>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance over a LAN
Date: 2004-07-23 11:43:07
Message-ID: 1090582986.34076.5.camel@jester (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Fri, 2004-07-23 at 01:50, William Carney wrote:
> Hello,
> Using a test client application that performs 100000 insert operations on a
> table, with the client application running on the same machine as the
> Postgres server, I get the following results for the time taken to run the
> test:
> Unix domain socket connection: 26 seconds
> Inet domain socket ('localhost'): 35 seconds

> The machines used are P4s running FreeBSD 5.2.1. The Postgres version is
> 7.4.3. Can anyone tell me why there's such a big difference?

Domains sockets have significantly less work to do than inet sockets as
well as less delays for the transmission itself.

In response to

pgsql-performance by date

Next:From: Dennis BjorklundDate: 2004-07-23 12:01:56
Subject: Re: Wrong index choosen?
Previous:From: Gaetano MendolaDate: 2004-07-23 08:26:52
Subject: Wrong index choosen?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group