Hi, Where do you exactly pass the option of --enable-oid32? Dariusz. Peter Boncz wrote:
since the last release, there is a storage/memory consumption optimization in place when using the configure option --enable-oid32, which causes tables to be restricted to 2Gtuples, but leads to smaller data storage for surrogate keys (oids). As a second effect, this configure setting also enables a more compact string heap organization (restricting the amount of string data in a single column to 32GB).
windows is configured by default with --enable-oid32
If you can live with these restrictions, you can also compile/get linux MonetDB binaries with --enable-oid32
-----Original Message----- From: Ying Zhang [mailto:Y.Zhang@cwi.nl] Sent: Monday, June 22, 2009 7:01 PM To: Communication channel for MonetDB users Subject: Re: [MonetDB-users] disk usage
Hello Dariusz,
The first thing came to my mind is the bits system. I guess your windows is 32bits, while your linux is 64 bits. Since, on 32bits systems, 'long', 'long int', oids and pointers are 4 bytes; while on they are 8 bytes. Thus, you data will most probably take more storage on a 64bits system, than on a 32bits system. How many more it is, depends on the type of your columns.
Regards,
Jennie
On Mon, Jun 22, 2009 at 12:35:52PM -0400, dariuszs wrote:
Hi, I've loaded 60 GB of data file into a table. On Windows (NTFS) the size of dbfarm changed to 80GB but on Linux (ext4 or reiserfs) dbfarm changed to 180GB. Why is that? Thanks. Dariusz.
-------------------------------------------------------------------------
-----
Are you an open source citizen? Join us for the Open Source Bridge
conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference:
$250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge. org
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
--------------------------------------------------------------------------- --- Are you an open source citizen? Join us for the Open Source Bridge conference! Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250. Need another reason to go? 24-hour hacker lounge. Register today! http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge. org _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.339 / Virus Database: 270.12.71/2178 - Release Date: 06/21/09 20:02:00
------------------------------------------------------------------------------ Are you an open source citizen? Join us for the Open Source Bridge conference! Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250. Need another reason to go? 24-hour hacker lounge. Register today! http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.o... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users