Re: PostgreSQL pre-fork speedup - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: PostgreSQL pre-fork speedup
Date
Msg-id 200405061612.i46GC8101437@candle.pha.pa.us
Whole thread Raw
In response to Re: PostgreSQL pre-fork speedup  (sdv mailer <sdvmailer@yahoo.com>)
Responses Re: PostgreSQL pre-fork speedup  (sdv mailer <sdvmailer@yahoo.com>)
List 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,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: "Merlin Moncure"
Date:
Subject: alter table alter columns vs. domains
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE TODO items