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

--
1G6
52 route de bischwiller
67300 Schiltigheim
Société de Services et de Formations en Logiciels Libres
http://1g6.biz
Tél : 06 64 63 70 35