Horton

Re: PostgreSQL pre-fork speedup

Thomas Swan <tswan@idigx.com>

View thread View on postgr.es
From: Thomas Swan <tswan@idigx.com>
To: sdv mailer <sdvmailer@yahoo.com>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, Rod Taylor <pg@rbt.ca>, Tatsuo Ishii <t-ishii@sra.co.jp>, Scott Marlowe <scott.marlowe@ihs.com>, steve@blighty.com, PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2004-05-06T16:54:52Z
Lists: pgsql-hackers 
sdv mailer wrote:

>Hi Bruce,
>
>Sorry for the confusion because Rod asked a question
>and I answered too quickly. This is what I mean.
>
>15x Slower:
>-----------
>Client <--TCP--> PgPool <--UNIX--> PostgreSQL
>Client <--TCP--> PgPool <--TCP--> PostgreSQL
>
>5x Faster:
>----------
>Client <--UNIX--> PgPool <--UNIX--> PostgreSQL
>Client <--UNIX--> PgPool <--TCP--> PostgreSQL
>
>
>Hope this helps! Pgpool speeds up connection time by
>5x with UNIX socket due to pre-fork and connection
>pooling. However, pgpool slows down by 15x under TCP
>socket for some unknown reason.
>
>
>
>  
>
Do you have SSL enabled on the postgresql server?  If you do, this would
account for the slower connect time over TCP/IP.