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, whole thread or download thread mbox)
Lists: pgsql-performance
[moved to pgsql-performance]
> > 	Currently I want to take a TPC-H test on postgresql-8.0.2. I
> > 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
> 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
> > Where can I download a client which connects to DB server through
> Get DBT3 from Sourceforge (search on "osdldbt").  This is OSDL's
> test.
> However, given your knowledge of PostgreSQL you're unlikely to get any
> kind of
> result you can use -- TPCH requires siginficant database tuning

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.


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-2017 The PostgreSQL Global Development Group