Re: Re: [GENERAL] PostgreSQL vs. MySQL - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Re: [GENERAL] PostgreSQL vs. MySQL
Date
Msg-id 200007100037.UAA04258@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] PostgreSQL vs. MySQL  (Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>)
List pgsql-hackers
> 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@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: Re: [SQL] MAX() of 0 records.
Next
From: Philip Warner
Date:
Subject: Re: Re: C language function dump problem