Re: strange postgresql x mysql comparison in forrester analyse - Mailing list pgsql-advocacy

From Greg Smith
Subject Re: strange postgresql x mysql comparison in forrester analyse
Date
Msg-id alpine.GSO.2.01.0910181659390.22935@westnet.com
Whole thread Raw
In response to Re: strange postgresql x mysql comparison in forrester analyse  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Responses Re: strange postgresql x mysql comparison in forrester analyse
List pgsql-advocacy
On Sun, 18 Oct 2009, Ron Mayer wrote:

> Would have been nice if they had pointed to the benchmark they had in
> mind.  The only well known published benchmark I see (on spec.org) that
> compares postgres to many of these other databases made us look OK to
> me.

Found the talk I was alluding to:
http://blogs.sun.com/jkshah/entry/postgresql_east_2008_talk_postgresql
Note the TCP-H summary on P26.  Out of the 21 queries in that standard
benchmark load, PostgreSQL basically doesn't handle 9 of them.  Makes it
hard for businesses to trust you can deploy it as a generic database
application for data-warehouse purposes knowing there are some sizable
holes there.  And it's difficult to push back and dispute claims of
benchmark issues with the database vs. the commercial products knowing
it's not hard to discover said holes.

> I think the problem is that we're comparing an apples (just the core
> postgres kernel) with oranges (the database kernels plus all the
> supporting tools and apps from other vendors).

Sure, but the larger point I was suggesting is that the way the analyst is
evaluating like that matches that of more business people than the
community may like to acknowledge.  There's a reason people bundle all
that stuff with their core database products.

Ultimately this is a hard issue to field.  If the comparison piece here
was instead EDB's bundling of Postgres with the whole fairly well
integrated development tool stack they make available now (note how big
the list at http://www.enterprisedb.com/products/download.do is getting
nowadays), the larger comparison might go off a bit better.  You know that
would raise a completely different set of criticism of the study from
within this community though.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-advocacy by date:

Previous
From: Ron Mayer
Date:
Subject: Re: strange postgresql x mysql comparison in forrester analyse
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: strange postgresql x mysql comparison in forrester analyse