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

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