- users-list - monetdb.org

[MonetDB-users] Can not allocate memory, MonetDB5
by forte712 14 Mar '08

14 Mar '08

Hi I've just downloaded a new version of MonetDB a few days ago and started testing it.. I tried inserting a 2.6G data file (12 columns, 32 million rows) and it works fine. But when I added 4 more columns of data to that data file (of type bigint, bringing the file size up to 3.9G), it fails saying !SQLException:importTable:failed to import table !ERROR: GDKload: cannot mmap(): name=20/2023, ext=tail.priv !OS: Cannot allocate memory !ERROR: GDKload failed: name=20/2023, ext=tail.priv I … [View More]

4 4

[MonetDB-users] Table space/size
by Iftikharn 14 Mar '08

14 Mar '08

Hi How to check that how much space a particular table has taken or what is the current size of a given tables in bytes etc. Because I am interested in writing a trigger when a particular table reaches a given size then the oldest of all rows, based on a time attribute should be deleted (I like to do it without counting the rows). Regards, Iftikhar -- View this message in context: http://www.nabble.com/Table-space-size-tp16040486p16040486.html Sent from the monetdb-users mailing list … [View More]

2 1

[MonetDB-users] Developing in MAL!
by Erik Holstad 13 Mar '08

13 Mar '08

Hi, I'm new to MonetDB, but are looking to develop my own interface towards the database, not using SQL, but just sticking with MAL or if possible C and just want to know what my options are? Is it, for example, possible to load you own MAL-files into the client, just for a test run or do you have to type in the commands line by line? And on the server side, how to you setup your own modules and libraries? Regards Erik Holstad

5 24

[MonetDB-users] JDBC insert performance
by chinarinde 11 Mar '08

11 Mar '08

Hi all, I am new to monetDB and ran into the following problem (I'll try to be as verbose as I can, perhaps it helps helping me): I've installed MonetDB server 5.0.0, clients and commons 1.18.2 and sql 2.18.2 on Ubuntu Feisty. Then I've taken the JDBC example which is available online and modified it to be able to insert data into a test database. More specifically I'm using prepared statements and executeBatch() together with the monetdb-1.6 JDBC driver. Which is quite successful until … [View More]

3 2

[MonetDB-users] Help me,please
by ssoor 05 Mar '08

05 Mar '08

Dear MonetDB's Group, I am a school student in china. I want to compile the Source code of MonetDB on WindowsXP. I have read your Documentations. But I lost. Can you send me the particular how to compile it with the MS visual studio 2005. Thanks you very much . And forgive my poor English. I hope your answer. Lin Mailing Address: ssoor(… [View More]

2 1

[MonetDB-users] Windows binary + Python2.4
by Pawel Lewicki 26 Feb '08

26 Feb '08

Hi, Is there any chance for Python extensions compiled for Python 2.4 for Windows? Paweł Lewicki

1 0

[MonetDB-users] Blacklisting certain XML elements
by jz＠uva 26 Feb '08

26 Feb '08

Dear all, I am wondering whether it is possible with MonetDB4/XQuery, PF/Tijah, to blacklist certain XML element names from being "shredded", and thus being indexed? If so, could someone tell me how? I hope this is the correct mailinglist for asking this question... Best, Junte

2 1

Re: [MonetDB-users] COPY TO corrupting data
by mobigital-nbl＠yahoo.com 26 Feb '08

26 Feb '08

Stefan Manegold wrote: > 32-bit system on 8 GB machines does not make much sense, does it? > A 32-bit systems can (at least per process) address at most 4 GB, usually > only 2 GB in practice... True, but doesn't seem like I am hitting the maximum process memory limit (not even approaching 1.5GB). > With 9M+ records of >= 438 byte each, your data is >=3.9 GB in size. > I'm not completely sure whether MonetDB temprarily need to hold all data > concurrently in its … [View More]

1 0

Re: [MonetDB-users] COPY TO corrupting data
by bunninge 25 Feb '08

25 Feb '08

-----Original Message----- From: Martin Kersten <Martin.Kersten(a)cwi.nl> Sent: Friday, February 22, 2008 17:07 To: Communication channel for MonetDB users <monetdb-users(a)lists.sourceforge.net> Subject: Re: [MonetDB-users] COPY TO corrupting data mobigital1 wrote: > FYI, i am using 500K rows at a time. > > I've seen the mserver5.exe process memory utilization go up to 13GB (free > memory was around 1.5 GB). > but then it winds down pretty quickly. > > > &… [View More]

1 0

[MonetDB-users] COPY TO corrupting data
by mobigital1 25 Feb '08

25 Feb '08

I am trying to load about 500M rows into a table with about 160 columns: column types: 7 columns of type "int" 2 columns of type "varchar(20)" 6 columns of type "varchar(10)" 1 columns of type "varchar(15)" 144 columns of type "real" on a system with 16 GB RAM , 64 bit windows server 2003 SP2. it takes some 20 hours to load the 100M rows, but when I reach that boundary, the server seems to crash and database becomes corrupt so that about 95M rows have 0 in numeric columns, blanks in … [View More]

4 7