From: Ron Mayer <rm_pg@cheapcomplexdevices.com>
To: Bill Moran <wmoran@collaborativefusion.com>
Subject: Re: PostgreSQL vs MySQL, and FreeBSD
Date: Fri, 09 Nov 2007 11:44:04 -0800
Message-ID: <4734B884.9080501@cheapcomplexdevices.com> (raw)
In-Reply-To: <20071109140454.924e94b1.wmoran@collaborativefusion.com>
References: <47344D43.5090506@geri.cc.fer.hr>
<47347F9F.1070309@laliluna.de>
<Pine.GSO.4.64.0711091107590.29551@westnet.com>
<20071109140454.924e94b1.wmoran@collaborativefusion.com>
Bill Moran wrote:
> On Fri, 9 Nov 2007 11:11:18 -0500 (EST)
> Greg Smith <gsmith@gregsmith.com> wrote:
>> On Fri, 9 Nov 2007, Sebastian Hennebrueder wrote:
>>> If the queries are complex, this is understable.
>> The queries used for this comparison are trivial. There's only one table
>> involved and there are no joins. It's testing very low-level aspects of
>> performance.
>
> Actually, what it's really showing is parallelism, and I've always
> expected PostgreSQL to come out on top in that arena.
Isn't it showing Postgres winning even without parallelism.
At 1 threads, Postgres looks like 800TPS where MysQL comes
in at about 600TPS on their Opteron charts.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rm_pg@cheapcomplexdevices.com, wmoran@collaborativefusion.com
Subject: Re: PostgreSQL vs MySQL, and FreeBSD
In-Reply-To: <4734B884.9080501@cheapcomplexdevices.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox