Re: PostgreSQL pre-fork speedup - Mailing list pgsql-hackers

From James Robinson
Subject Re: PostgreSQL pre-fork speedup
Date
Msg-id 9BC2443E-9F7C-11D8-9C07-000A9566A412@socialserve.com
Whole thread Raw
In response to Re: PostgreSQL pre-fork speedup  (sdv mailer <sdvmailer@yahoo.com>)
List pgsql-hackers
On May 6, 2004, at 12:19 PM, sdv mailer wrote:

>
> 15x Slower:
> -----------
> Client <--TCP--> PgPool <--UNIX--> PostgreSQL
> Client <--TCP--> PgPool <--TCP--> PostgreSQL
>
> 5x Faster:
> ----------
> Client <--UNIX--> PgPool <--UNIX--> PostgreSQL
> Client <--UNIX--> PgPool <--TCP--> PostgreSQL
>

If the problem were in the TCP stack utilization itself, one would 
expect case #1 to be equivalent to case #4, since both use one UNIX 
domain connection and one TCP connection. Likewise, one would expect 
case #2 to be the worst.

Does PgPool markedly differ codewise when reading from TCP socket 
instead of UNIX domain? Pulling down code ...

----
James Robinson
Socialserve.com



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: ALTER TABLE TODO items
Next
From: sdv mailer
Date:
Subject: Re: PostgreSQL pre-fork speedup