Hello,
I try to understand the use of disk space after disk full. I look at the files in the folder base /bat/
root@groupelemonde:/var/lib/monetdb/lemonde# ls -l bat/06/676.* -rw------- 1 monetdb monetdb 1579876352 oct. 15 17:42 bat/06/676.tail -rw------- 1 monetdb monetdb 3606183936 nov. 28 15:03 bat/06/676.theap
And i look sys.storage SELECT location,columnsize,heapsize FROM sys.storage WHERE location LIKE '06/676';
+----------+------------+------------+ | location | columnsize | heapsize | +==========+============+============+ | 06/676 | 1579850648 | 3606183936 |
676.tail is columnsize column 676.theap is heapsize column
but I have 2 large file (> 100 Go)
root@groupelemonde:/var/lib/monetdb/lemonde# ls -l bat/06/670.* -rw------- 1 monetdb monetdb 120641335296 nov. 28 14:28 bat/06/670.tail
root@groupelemonde:/var/lib/monetdb/lemonde# ls -l bat/06/636.* -rw------- 1 monetdb monetdb 144702111744 nov. 28 12:32 bat/06/636.tail
sql>select location,columnsize,heapsize from sys.storage WHERE location IN ('06/636','06/670'); 0 tuples (34.050ms)
the modification time of two files is identical to the full disk on my server.
Is what I can delete these 2 files ?
Pierre