SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-11-2008, 04:35 AM
| ||||
| ||||
 How two perform TPC-H test on postgresql-8.0.2 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      |
|
04-11-2008, 04:35 AM
| |||
| |||
| Re: 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/k...te/osdl_dbt-3/ -Neil ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings |
|
04-11-2008, 04:35 AM
| |||
| |||
| Re: 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. 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 majordomo@postgresql.org |
|
04-11-2008, 04:36 AM
| ||||
| ||||
| 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
Linear Mode
