On 24/10/14 10:37, Pierre-Adrien Coustillas wrote:
Hello Hi
Before working with optimizer, Stethoscope and Tomograph, first I have to defragment the fragmented tables. How to detect fragmented tables? The heap size is larger then the expected count would indicate. Write a script that reads heapsize column? The storagemodel could give you hints on expected sizes.
select *, (heapsize / 1021/1024/1024) as giga from sys.storage heapsize ORDER BY DESC LIMIT 20; What do you think? select *, (heapsize / 1021/1024/1024) as giga from sys.storage order by heapsize desc limit 20;
or a more specific sql query by reading the column "count", "typewidth", "ColumnSize" and "heapsize"?
regards, Martin
thank
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
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list