How two perform TPC-H test on postgresql-8.0.2

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

How two perform TPC-H test on postgresql-8.0.2

innodb
        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?

        Your sincerely!



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq
Reply | Threaded
Open this post in threaded view
|

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

Neil Conway-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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
Reply | Threaded
Open this post in threaded view
|

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

Andrew Dunstan
In reply to this post by innodb


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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [hidden email]
Reply | Threaded
Open this post in threaded view
|

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

Josh berkus
In reply to this post by innodb
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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [hidden email] so that your
       message can get through to the mailing list cleanly