Hi Martin,

Thanks for your help. The script working now.

Regards, Pranav

Martin Kersten wrote:

Pranav Vaidya wrote:

...

Hi,

I am new to MonetDB and I am trying to run the TPC-H benchmarks and I was able to successfully load and execute the benchmarks in MonetDB version 4. I also verified whether the tables were populated using Dbvis. However, what seems to fail is the lack of a function called optimizer_stats() in the run.all script.

Is this a procedure or a function defined additionally which is needed. And why is it not present ? Do I need to run some additional scripts to have this run.all script go through successfully without any errors.

Thanks and Regards, Pranav.

Hello, you don't need this call per se. It can be removed from the queries. Alternatively, you can find the optimizer_stats script in sql/src/sql directory. Just run it once against your server is sufficient to make this function known.

regards, good luck, Martin

---

This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

Hi Neil,

Thanks

I got the statistics I was interested in.

Regards, Pranav.

Niels Nes wrote:

On Wed, Oct 03, 2007 at 01:51:04PM -0700, Pranav Vaidya wrote:

...

Hi,

I am new to MonetDB and I am trying to run the TPC-H benchmarks and I was able to successfully load and execute the benchmarks in MonetDB version 4. I also verified whether the tables were populated using Dbvis. However, what seems to fail is the lack of a function called optimizer_stats() in the run.all script.

Is this a procedure or a function defined additionally which is needed. And why is it not present ? Do I need to run some additional scripts to have this run.all script go through successfully without any errors.

Indeed you need to load this extra function.

run the following command with a running server. mclient -lsql < src/sql/stats.sql

The calls to optimizer_stats() are however only needed for the nightly testing. For running experminents simply remove these calls.

Niels

...

Thanks and Regards, Pranav.

-- View this message in context: http://www.nabble.com/What-is-optimizer_stats%28%29-tf4564307.html#a13027620 Sent from the monetdb-users mailing list archive at Nabble.com.

---

This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

--

Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

---

This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users