Horton

Re: PostgreSQL pre-fork speedup

sdv mailer <sdvmailer@yahoo.com>

View thread View on postgr.es
From: sdv mailer <sdvmailer@yahoo.com>
To: Rod Taylor <pg@rbt.ca>
Cc: 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-06T15:30:01Z
Lists: pgsql-hackers 
Pgpool connects to PostgreSQL on UNIX socket. I also
ran on TCP socket but there is no significant
difference if I recall correctly due to the inherent
nature of connection pooling or pre-fork technology. 
;-)


--- Rod Taylor <pg@rbt.ca> wrote:
> > However, when I tried TCP socket, Pgpool was
> actually
> > slower by 15x !! Perhaps you can clarify why the
> TCP
> > socket is so much slower?
> 
> How did you have pgpool configured to connect to the
> database? Domain
> socket or tcpip?
> 



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