Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] How two perform TPC-H test on postgresql-8.0.2

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>, "innodb" <innobase(at)163(dot)com>
Subject: Re: [HACKERS] How two perform TPC-H test on postgresql-8.0.2
Date: 2005-06-27 18:14:10
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3415C2BD1@Herge.rcsinc.local (view raw or flat)
Thread:
Lists: pgsql-performance
[moved to pgsql-performance]
> > 	Currently I want to take a TPC-H test on postgresql-8.0.2. I
have
> > downloaded the DBGEN and QGEN from the homepage of TPC. But I
> encountered
> > many problems which forced me to request some help. 1. How to load
the
> data
> > from flat file generated by dbgen tool? To the best of my knowledge,
> there
> > is a SQL Loader in Oracle 2. How to simulate the currency
environment?
> > Where can I download a client which connects to DB server through
ODBC?
> 
> Get DBT3 from Sourceforge (search on "osdldbt").  This is OSDL's
TPCH-like
> test.
> 
> However, given your knowledge of PostgreSQL you're unlikely to get any
> kind of
> result you can use -- TPCH requires siginficant database tuning
knowledge.

I don't necessarily agree.  In fact, I remember reading the standards
for one of the TPC benchmarks and it said you were not supposed to
specifically tune for the test.  Any submission, including one with
stock settings, should be given consideration (and the .conf settings
should be submitted along with the benchmark results).  This can only
help to increase the body of knowledge on configuring the database.

Merlin

pgsql-performance by date

Next:From: Bricklen AndersonDate: 2005-06-27 18:15:06
Subject: Re: ETL optimization
Previous:From: Eric LauzonDate: 2005-06-27 14:46:46
Subject: Re: PERFORMANCE ISSUE ODBC x LIBPQ C++ Application

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group