3

I'm using TPC-DS to run some benchmarks on a few versions of postgres that I have. I noticed that there is no template for generating the TPC-DS queries with the target database as postgres. The query_templates directory contains template files for ansi, sqlserver, db2, oracle, and netezza, but none for postgres.

I've tried running the queries generated by each of the previously listed targets on postgres, but they all seem to have some kind of syntax that postgres doesn't support, because most of them fail to run.

Is it possible to generate these TPC-DS queries for postgres? Or is there a postgres.tpl file that can be downloaded somewhere?

Improve this question

2 Answers 2

Reset to default
4

Not sure about the TPC-DS, but I know that HammerDB will perform a TPC-H(ad hoc DSS) benchmark test against PostgreSQL. If you're looking for a benchmark, but not specifically a TPC-DS, this is a good tool for testing.

Improve this answer
1
  • Thanks for the quick reply. I have already run a bunch of TPCH benchmarks on my postgres databases. I specifically need to use TPC-DS because of its high-volume and high-CPU/IO load. Commented Aug 8, 2013 at 20:34
0

Util HammerDB has addon Autohamer which can create TPC-DS tests, you can check this link http://hammerora.sourceforge.net/Autohammer/content/ch01.html

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.