Hello all,
I'm conducting an experiment to show pros/cons of certain DBs and I need to investigate
query compilation performance in details. For this,
Is there any way to measure the elapsed time in query parsing/compilation time in MonetDB?
Also is there any document out there to show the query parsing/compilation details?
What I find for timing is only "-i" flag which gives an overall timing stat.
I'd be glad for any help.
Thank you
Mustafa Korkmaz
Hi,
Whenever I try to drop I sequence I get the following error:-
DROP SEQUENCE seq_12129;
DROP SEQUENCE: unable to drop sequence seq_12129 (there are database objects which depend on it)
I have dropped all the tables in the current schema, but I am still getting this error. Is there a way to find out what database object depends on this sequence?
Anu
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