| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Bjorklund | 2004-07-23 12:01:56 | Re: Wrong index choosen? |
| Previous Message | Gaetano Mendola | 2004-07-23 08:26:52 | Wrong index choosen? |