Re: PostgreSQL vs MySQL, and FreeBSD

On Nov 11, 2007, at 2:17 PM, Joshua D. Drake wrote:

> Dimitri wrote:
>> Seems to me there is more thread model implementation problem on
>> FreeBSD, and databases just reflecting it... Most of the test I done
>> on Solaris show the same performance level on the same short READ-
>> only
>> queries for MySQL and PostgreSQL.
>> And to be honest till the end, thread model should be far faster
>> (context switching between threads is way faster vs processes), but -
>> as I say usually - even a very good idea may be just wasted by a poor
>> implementation... And in case of MySQL they have too much locking to
>> manage concurrency between threads which kills all thread model
>> benefits... Also, to compare apples to apples, they should run this
>> test from remote client  rather locally on the same host - however in
>> this case the result for PostgreSQL will mostly depends on client
>> implementation: if client implements reading via CURSOR (quite
>> often),
>> reading will generate 4x times more intensive network traffic than
>> necessary and final PostgreSQL result will be worse...
>> Reading this article I'm just happy for them to see progress done
>> on FreeBSD :-)
>> As well to demonstrate OS parallelism it's not so impressive to see
>> 4CPU server results rather 8CPU or 32threaded Niagara... Don't know
>> why they did not present similar performance graphs for these
>> platform, strange no?...
>
> I don't find it strange. I would rather see benchmarks on what the
> majority of people running on the platform are going to run.
>
> Most people don't run 8core machines and they especially don't run
> 32thread Niagra boxes.

Wait!  So, what do you check you're email with? :)

Erik Jones

Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com