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