Re: Re: [GENERAL] PostgreSQL vs. MySQL

> Louis Bertrand wrote:
> >
> > There's a benchmark/review comparing PostgreSQL and MySQL on PHP Builder:
> > http://www.phpbuilder.com/columns/tim20000705.php3
>
> I'm wondering about the comments that postgres is slower in connection
> time, could this be related to that libpq always uses asynchronous
> sockets to connect? It always turns off blocking and then goes through a
> state machine to go through the various stages of connect, instead of
> just calling connect() and waiting for the kernel to do its thing. Of
> course asynchronous connecting is a benefit when you want it. Or is the
> overhead elsewhere, and I'm just being paranoid?

The truth is, we really don't know what it is.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026