[Pgpool-general] best location for pgpool in a 2 machine arrangement

David Boreham david_list at boreham.org
Tue May 2 13:28:20 UTC 2006


Andrew Sullivan wrote:

>You seem to be in some confusion here over the nature of socket
>interfaces.  Certainly on every UNIX I know of, if UNIX domain
>sockets are available, they are faster than the TCP/IP stack. 
>They're even faster on FreeBSD, which has what is widely regarded as
>a very fast stack.  If you can use domain sockets, they're usually
>faster.
>  
>
Oh please, where did I say that domain sockets aren't faster ?
I said that they won't speed up this database application.
You seem to be confused about how to read ;)

>Now, whether the connection is your bottleneck is quite another
>matter.  Often it isn't: I've heard people say, "Oh, use domain
>sockets: TCP/IP is too slow," but when you look at the application,
>they're sending 40 round trips per transaction.  That's going to lose
>even if you use the super-experimental-secret quantum computing
>connection.  So I agree that they're no magic bullet.
>  
>
That's good. So we're in agreement (well, except about using HTML
e-mail in the 21st c.).








More information about the Pgpool-general mailing list