May 2009 - users-list

[MonetDB-users] Extra Tables and performance
by Mag Gam 10 May '09

10 May '09

I was wondering if I added referential integrity with a foreign keys will slow down a query. I know the loading will take longer but would MonetDB be much slower if I was doing a query? TIA

2 2

[MonetDB-users] Redundant data
by Mag Gam 09 May '09

09 May '09

Hello All, I am very new to MonetDB and I am very pleased with its performance at our university. Basically, I have data which is stored on our Unix filesystem. /research_data/life/YYYY/MM/DD/species (there are over 100 species files) I then created a very large csv file which is traverses thru this data. The file size is about 2GB. The table I created looks like this t1 ( t as timestamp species as varchar(10) weight as float color as varchar(10) ) The file species.csv looks like this … [View More]

2 2

[MonetDB-users] porting a financial time series database from mysql (how to represent datetime fields)
by Tom H 08 May '09

08 May '09

Hi monetDb collective, I am porting a test database over from a MySQL schema, and it currently looks like this; CREATE TABLE `MSFT` ( `date` datetime default NULL, `o` decimal(10,0) default NULL, `h` decimal(10,0) default NULL, `l` decimal(10,0) default NULL, `c` decimal(10,0) default NULL, `v` decimal(10,0) default NULL, `a` decimal(10,0) default NULL, `period` varchar(12) default 'daily' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1) Whats the equivalent monetDB method for … [View More]

1 1

[MonetDB-users] Trigger oddities
by Bram Van Dam 08 May '09

08 May '09

Hi, I'm experiencing some strange trigger behaviour. Not sure if I'm simply missing something, or if I've run into a bug. create table t1 (id serial, toggle boolean); create table t2 (id serial, ref bigint); insert into t1 (toggle) values (false); insert into t1 (toggle) values (false); create trigger updateMe after update on t1 referencing new row new_row for each row when new_row.toggle = true insert into t2 (ref) values (new_row.id); update t1 set toggle = true where id = 1; … [View More]

2 2

[MonetDB-users] clarity on creating users/reseting passwords
by Tom H 08 May '09

08 May '09

Hi, I need to reset some passwords on a monetDB5 installation, and I am not clear on how to do it. Currently I can't login at all. Is there a way to enter single-user mode, or something so I can reset the monetDB user password? Also, I really don't understand the difference between running monet as mserver5 and Merovingian. Basically I want to run the server from an init.d script, which should I use? At the moment I am running the server like so; [root@localhost ~]# mserver5 --dbinit="… [View More]

2 1

[MonetDB-users] Primary-Foreign keys
by Alex Bo. 07 May '09

07 May '09

Hi, I wanted to ask what I should expect in terms of performance out of primary-foreign keys. Do join queries that have primary keys defined on their tables return faster? Are such joins materialized in the database? If not - is there any other way to control materialization of joins? Thanks. -- View this message in context: http://www.nabble.com/Primary-Foreign-keys-tp23428537p23428537.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] copy into from a file hangs
by Venu Alatzeth 06 May '09

06 May '09

Hi, I am evaluating MonetDB server v5.8.4, based on kernel v1.26.4 on FreeBSD 6.2 Loading data into a table from a file seem to hang, with mserver using high CPU. The file has only 10 records. If I use stdin instead of a file name the data can be loaded. Here is the debug output. openRead(nil) does not seem right. shouldn't it be openRead('/tmp/head.txt') ? sql>debug copy 10 records into "log_0" from '/tmp/head.txt' using delimiters '|'; mdb># mdb.start(); mdb>n mdb># user.… [View More]

2 1

[MonetDB-users] Cannot install MonetDB with monetdb-install.sh
by Stefan Klinger 06 May '09

06 May '09

Hello, I'm having problems installing a current (--nightly=current) version of MonetDB: Running monetdb-install.sh provied at [1] displays a lot of HTTP 404 error messages. Then it successfully downloads a 0Byte MonetDB4-XQuery.tar.gz which it cannot unpack. The logfile is attached. Tested on openSUSE 10.2 and Debian GNU/Linux squeeze/sid. Just ask if you need more details. Thank you very much, Stefan ____________________ [1] http://monetdb.cwi.nl/projects/monetdb/Assets/monetdb-install.… [View More]

2 1

[MonetDB-users] Query failure with 'recycle' in optimizer
by Alex Bo. 06 May '09

06 May '09

Hi, I have a query that runs without any problems when the default optimizer settings are used. But once I add 'recycle' to the existing optimizer modules, the query doesn't return. Mserver seems to be stuck in an infinite loop with 50% CPU usage. I am running Monet compiled from CVS on Windows. This is the query: select sum(t1."AddressID"), "hour"(t1."ModifiedDate") as aa from "schema1"."CustomerAddress" as t1 inner join "schema1"."CustomerAddress"as t2 on t1."CustomerID" = t2."… [View More]

5 5