Horton

Re: PostgreSQL pre-fork speedup

sdv mailer <sdvmailer@yahoo.com>

View thread View on postgr.es
From: sdv mailer <sdvmailer@yahoo.com>
To: Tatsuo Ishii <t-ishii@sra.co.jp>
Cc: pgman@candle.pha.pa.us, pg@rbt.ca, scott.marlowe@ihs.com, steve@blighty.com, pgsql-hackers@postgresql.org
Date: 2004-05-12T14:54:16Z
Lists: pgsql-hackers 
I ran the new Pgpool-1.2.2 and it was a bit faster on
the TCP but still slower than on UNIX socket. I used
the same script as before.

TCP Socket (Pgpool 1.2.0)
----------
2.39 sec

TCP Socket (Pgpool 1.2.2)
----------
0.80 sec
0.80 sec
0.79 sec

UNIX Socket (Pgpool 1.2.2)
-----------
0.026 sec
0.027 sec
0.027 sec

Direct TCP connection (no pgpool)
---------------------------------
0.16 sec
0.15 sec
0.16 sec


PgPool on TCP is still slower than direct connection
but much faster than v1.2. Any other areas that can be
improved?

Regards,



	
		
__________________________________
Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2'
http://movies.yahoo.com/showtimes/movie?mid=1808405861