Re: PostgreSQL pre-fork speedup

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(at)rbt(dot)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(at)postgresql(dot)org)
>

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