How two perform TPC-H test on postgresql-8.0.2

innodb wrote:

Currently I want to take a TPC-H test on postgresql-8.0.2.

You might want to take a look at the TPC-H implementation here:

http://www.osdl.org/lab_activities/kernel_testing/osdl_database_test_suite/osdl_dbt-3/

-Neil

innodb wrote:

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?

To be brutally frank, if you have to ask these questions you should not
be running TPC-H benchmarks, IMNSHO. You results are very unlikely to be
fair to you or to PostgreSQL.

TPC-H requires mild modification (took me about 15 minutes) to produce
postgres-ready output, which can be loaded via the COPY command, which
is designed for bulk loading data.

cheers

andrew

Inno,

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.
How about you ask the questions you really want to know on PGSQL-PERFORMANCE
mailing list?

--
Josh Berkus
Aglio Database Solutions
San Francisco