Thread: TPC-H
Hi, Does anyone know how to install a TPC-H database in postgreSQL?? Thanks in advance.
f2160528@est.fib.upc.es wrote: > Hi, > > Does anyone know how to install a TPC-H > database in postgreSQL?? ReHi, what exactly do you mean with "install a TPC-H database"? I long have evidence that most people who talk about benchmarks never really read any specs. This is not meant personal against you or anyone else around here, but who here ever read the TPC-C, -H or -W specifications? Neither the pgbench we have, nor the FUD the MySQL lemmings love to believe in has anything to do with the word benchmark. Thus, asking for a TPC-H (the datawarehouse test suite) is not bad. But one big mistake made over and over again is, that people think TPC suites are database benchmarks. They are NOT. In fact, they describe what the TPC calls a System Under Test (SUT) on a business process level and a couple of technical aspects for a possible implementation. What someone finally uses to implement the described application, is up to her. So for the TPC-W for example, it is up to you if you implement that entire book shop in PHP, J2EE, ASP, ADP or CGI. You are free to use Apache, IIS, AOLServer, Tomcat or any other thing that is intended to put out dynamic content on port 80. The database behind it (if you use an SQL database at all) is just one little piece of the entire SUT. The result of the entire thing will NOT tell you MySQL is faster than PostgreSQL (first because it's not, second that's not what the test questions at all). For more information you can find the specifications of all the test suites on the website of the Transaction Processing Performance Council http://www.tpc.org. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com # _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
> Is there a table definition script available that is widely used for TPC-H in Postgresql to get results that can be compared?
There are multiple "PostgreSQL + TCP-H" projects on the github -
There are multiple "PostgreSQL + TCP-H" projects on the github -
Maybe you can reuse some ideas ...
https://github.com/search?q=%22TPC-H%22+postgresql&type=Repositoriesregards,
Imre
Malte Vesper <malte.vesper@gmx.net> ezt írta (időpont: 2018. júl. 15., V, 15:31):
Hello, I am trying to run TPC-H on PostgreSQL. While I was able to create the tables and run the queries, I am wondering if there is a table definition forTPC-H and PostgreSQL that is generally used, as far as I understand the TPC-H user can choose to create indices or preprocess data in individual tablesto quite an extent (i.e. CLUSTER seems allowed), leading to unexpected/very different results depending on the table definition (i.e. https://www.postgresql.org/message-id/CAKJS1f-erAogxxd=4tr2rLukoy5M-Or+djyZr2rbmAnZ35T+eg@mail.gmail.com).
Is there a table definition script available that is widely used for TPC-H in Postgresql to get results that can be compared?
Kind regards,
Malte Vesper