Hi - how can I tell how much disk storage space on of my tables is using?
I tried one rough way but not sure if it is accurate. Basically I did a linux
du command and looked at the farmdb dir root, then imported about 2M rows, then
looked a tthe du number again. But it only went up about 1.5MB for 2M rows of
data?
There are about 150 columns but only about 30-40 columns for any given row are
populated. Certainly this would be fantastic if the compression is really this
good! Seems possible, but I wasn't sure if this technique was accurate and if
there was a better way.
Also on a related note - is there any detailed information on what types of
compression and encoding MonetDB uses. For instance does it use Run Length
Encoding or deltas or other such methods?
And are there query plans / optimizers of any sort that you can feed MonetDB
and it will optimize the layout or create internal subtables to help speed the
types of queries we will be making?
Thank you!
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers
