Hi David, there (currently?) is no simple/convenient way in MonetDB to get the amount of disk space occupied by an individual SQL table. A simple work-around is to (dump each table and) load each table into a distinct new empty database, and then check the size of each dbfarm/database_name/ directory. Hope this helps you further. Stefan On Tue, Oct 06, 2009 at 05:59:43AM -0700, david85 wrote:

Ok I found out how one can determine the overall size of the DB, and the memory pagesize, i.e.: In the mserver type: variable_name := bbp.getDiskSpace(); io.print(variable_name);

and

variable_name := bbp.getPageSize(); io.print(variable_name);

However, I still dont know how I can get the size of a specific table.

Regards,

david

david85 wrote:

...

Hello,

I am currently trying to figure out how I can determine the size, i.e. the disk space, of the different tables. I know that they are stored in the dbfarm/database_name/bat folder, but I don't know which folder holds the data for which table. I looked at the manual but the bbp.getDiskSpace command didn't work (or maybe I used it wrong). I have also searched for this topic, but there was no concrete answer. Thank you in advance.

Best Regards

-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |