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