Horton

Re: PostgreSQL pre-fork speedup

Bruce Momjian <pgman@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: sdv mailer <sdvmailer@yahoo.com>
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:12:08Z
Lists: pgsql-hackers 
sdv mailer wrote:
> 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. 
> ;-)

I am confused.  First you said TCP was slower, but now you say it isn't.

---------------------------------------------------------------------------


> --- 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 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073