DBT-3 (TPC-H derivative) test kit
Greetings everyone, I just wanted to share what I've started with a test kit for MonetDB, hoping it will be useful for development efforts: http://sourceforge.net/p/osdldbt/dbt3/ci/master/tree/ The kit also relies on some additional scripts from here: http://sourceforge.net/p/osdldbt/dbttools/ci/master/tree/ Here is an example of a test report that the kit produces: http://mw2q.github.io/dbt3-monetdb-sample/ I'm hoping that the ability to collect low level profiling (on Linux), and collecting system stats will be helpful. For example, using Linux perf to collect data per query in the Power and Throughput Tests. The kit could still use a little help, and I'm not sure if I'm doing things in the best way. If it seems useful, please let me know how the kit can be improved. Thanks! Regards, Mark -- Mark Wong http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services
Hello Mark, Thank you very much for sharing this with the community. In case you don’t already know, MonetDB has several low level profilers [1], particularly tomograph, that provide you various sys. resource consumption information of query execution. Maybe they are useful for you. Regards, Jennie [1] https://www.monetdb.org/Documentation/Manuals/MonetDB/Profiler
On Dec 07, 2015, at 18:22 , Mark Wong wrote:
Greetings everyone,
I just wanted to share what I've started with a test kit for MonetDB, hoping it will be useful for development efforts: http://sourceforge.net/p/osdldbt/dbt3/ci/master/tree/
The kit also relies on some additional scripts from here: http://sourceforge.net/p/osdldbt/dbttools/ci/master/tree/
Here is an example of a test report that the kit produces: http://mw2q.github.io/dbt3-monetdb-sample/
I'm hoping that the ability to collect low level profiling (on Linux), and collecting system stats will be helpful. For example, using Linux perf to collect data per query in the Power and Throughput Tests.
The kit could still use a little help, and I'm not sure if I'm doing things in the best way. If it seems useful, please let me know how the kit can be improved. Thanks!
Regards, Mark
-- Mark Wong http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services _______________________________________________ developers-list mailing list developers-list@monetdb.org https://www.monetdb.org/mailman/listinfo/developers-list
Hi Jennie, On 12/07/15 13:03, Ying Zhang wrote:
Hello Mark,
Thank you very much for sharing this with the community. In case you don’t already know, MonetDB has several low level profilers [1], particularly tomograph, that provide you various sys. resource consumption information of query execution. Maybe they are useful for you.
Regards,
Jennie
[1] https://www.monetdb.org/Documentation/Manuals/MonetDB/Profiler
Thanks for the reference, that does look very helpful for collecting profiling data. To be honest, I'm not sure how much time I have to incorporate that myself, but I'm happy to take any patches. And MonetDB is welcome to extract anything from the DBT-3 kit if it is better served that way. Regards, Mark -- Mark Wong http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services
participants (2)
-
Mark Wong
-
Ying Zhang