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-06T17:06:41Z
Lists: pgsql-hackers 
I compared against both TCP and UNIX direct
connections. No SSL, no authentication. See benchmark
results posted below again:

Direct
------
0.144 sec. Client <--UNIX--> PG
0.152 sec. Client <--TCP--> PG

5x Faster
---------
0.027 sec. Client <--UNIX--> Pgpool <--UNIX--> PG
0.028 sec. Client <--UNIX--> Pgpool <--TCP--> PG

15x Slower
----------
2.39  sec. Client <--TCP--> Pgpool <--UNIX--> PG
2.40  sec. Client <--TCP--> Pgpool <--TCP--> PG




	
		
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover