Re: PostgreSQL vs MySQL, and FreeBSD

Поиск
Список
Период
Сортировка
От Ron Mayer
Тема Re: PostgreSQL vs MySQL, and FreeBSD
Дата
Msg-id 4734B884.9080501@cheapcomplexdevices.com
обсуждение исходный текст
Ответ на Re: PostgreSQL vs MySQL, and FreeBSD  (Bill Moran <wmoran@collaborativefusion.com>)
Ответы Re: PostgreSQL vs MySQL, and FreeBSD  (Dimitri <dimitrik.fr@gmail.com>)
Список pgsql-performance
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.

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: work_mem and shared_buffers
Следующее
От: Erik Jones
Дата:
Сообщение: Re: work_mem and shared_buffers