Horton

Re: PostgreSQL pre-fork speedup

sdv mailer <sdvmailer@yahoo.com>

View thread View on postgr.es
From: sdv mailer <sdvmailer@yahoo.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: 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:19:56Z
Lists: pgsql-hackers 
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 Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover