Re: PostgreSQL TPC-H test result? - Mailing list pgsql-general

From Brent Wood
Subject Re: PostgreSQL TPC-H test result?
Date
Msg-id 48C774540200007B0001525D@gwia1.ham.niwa.co.nz
Whole thread Raw
In response to PostgreSQL TPC-H test result?  ("Amber" <guxiaobo1982@hotmail.com>)
Responses Re: PostgreSQL TPC-H test result?  (Martijn van Oosterhout <kleptog@svana.org>)
Re: PostgreSQL TPC-H test result?  (Andrew Sullivan <ajs@commandprompt.com>)
List pgsql-general
My 02c,

Pg does itself no favours by sticking with such pessimistic defaults, and a novice user wanting to try it out will find
tweakingthe pg configuration files for performance quite complicated. 

Given the general increase in typical hardware specs these days, perhaps the default pg specs could be set for higher
specsystems? 

Or perhaps the standard install could come with 2 or 3 versions of the config files, & the user can simply
rename/invokethe one that fits their system best? I figure (somewhat simplistically) that most settings are more
relatedto available memory than anything else, so perhaps config files for typical 1Gb, 4Gb & 8Gb systems could be
providedout of the box to make initial installs simpler? 

Cheers,

  Brent Wood

Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand
>>> Andrew Sullivan <ajs@commandprompt.com> 09/10/08 3:47 AM >>>
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
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

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


pgsql-general by date:

Previous
From: "Benjamin Reed"
Date:
Subject: Re: OS X library path issues for libpq (ver 8.3)
Next
From: Martijn van Oosterhout
Date:
Subject: Re: PostgreSQL TPC-H test result?