Re: [MonetDB-users] [Monetdb-developers] the database and index size

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512

Op 01-04-10 17:33, Mo Zhou schreef:

Does monetdb compress data in the database? I load plain text file (12M) into a database with only one table. I shut down the database right after that and check the size of the database. The database size is only 8M.

Obviously the amount of storage required for storing integers larger than 4 digits in plain text is higher than the amount of data that is required to represent a 4byte integer.

Regarding to strings best effort deduplication is choosen. Like with any fileformat there is some metadata overhead.

Stefan