Category: PostgreSQL General List


Article: PostgreSQL TPC-H test result?



25 items found, displaying 1 to 5.[First/Prev] 1, 2, 3, 4, 5 [Next/Last]
Id date Message
2008-09-11 22:36:45.0 I read something from http://monetdb.cwi.nl/projects/monetdb/SQL/Benchmark/TPCH/index.html saying that PostgreSQL can't give the correct result of the some TPC-H queries, I wonder is there any official statements about this, because it will affect our plane of using PostgreSQL as an alternative because it's usability. BTW I don't think PostgreSQL performances worse because the default configuration usually can't use enough resources of the computer, as as memory.
2008-09-09 07:46:20.0
149511 2008-09-09 07:46:20.0 On Tue, Sep 09, 2008 at 07:59:49PM +0800, Amber wrote:

> I read something from
> http://monetdb.cwi.nl/projects/monetdb/SQL/Benchmark/TPCH/index.html

Given that the point of that "study" is to prove something about
performance, one should be leery of any claims based on an "out of the
box" comparison. Particularly since the "box" their own product comes
out of is "compiled from CVS checkout". Their argument seems to be
that people can learn how to drive CVS and to compile software under
active development, but can't read the manual that comes with Postgres
(and a release of Postgres well over a year old, at that).

I didn't get any further in reading the claims, because it's obviously
nothing more than a marketing effort using the principle that deriding
everyone else will make them look better. Whether they have a good
product is another question entirely.

A
--
Andrew Sullivan
noway@spam.com
+1 503 667 4564 x104
http://www.commandprompt.com/

--
Sent via pgsql-general mailing list (pgsql-noway@spam.com)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
149570 2008-09-09 09:18:52.0 Yes, we don't care about the performance results, but we do care about the point that PostgreSQL can't give the correct results of TPC-H queries.

--------------------------------------------------
From: "Andrew Sullivan" <noway@spam.com>
Sent: Tuesday, September 09, 2008 8:39 PM
To: <pgsql-noway@spam.com>
Subject: Re: [GENERAL] PostgreSQL TPC-H test result?

> On Tue, Sep 09, 2008 at 07:59:49PM +0800, Amber wrote:
>
>> I read something from
>> http://monetdb.cwi.nl/projects/monetdb/SQL/Benchmark/TPCH/index.html
>
> Given that the point of that "study" is to prove something about
> performance, one should be leery of any claims based on an "out of the
> box" comparison. Particularly since the "box" their own product comes
> out of is "compiled from CVS checkout". Their argument seems to be
> that people can learn how to drive CVS and to compile software under
> active development, but can't read the manual that comes with Postgres
> (and a release of Postgres well over a year old, at that).
>
> I didn't get any further in reading the claims, because it's obviously
> nothing more than a marketing effort using the principle that deriding
> everyone else will make them look better. Whether they have a good
> product is another question entirely.
>
> A
> --
> Andrew Sullivan
> noway@spam.com
> +1 503 667 4564 x104
> http://www.commandprompt.com/
>
> --
> Sent via pgsql-general mailing list (pgsql-noway@spam.com)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
> -- Sent via pgsql-general mailing list (pgsql-noway@spam.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
149622 2008-09-09 10:23:39.0 On Tue, Sep 9, 2008 at 7:06 AM, Amber <noway@spam.com> wrote:
> Yes, we don't care about the performance results, but we do care about the point that PostgreSQL can't give the correct results of TPC-H queries.

It would be nice to know about the data, queries, and the expected
results of their tests just so we could see this for ourselves.


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

--
Sent via pgsql-general mailing list (pgsql-noway@spam.com)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Questions or comments? Feel free to post them here. No login or id required.

Valid XHTML 1.0!
Site Map >>