[MonetDB-users] Table space/size
Hi How to check that how much space a particular table has taken or what is the current size of a given tables in bytes etc. Because I am interested in writing a trigger when a particular table reaches a given size then the oldest of all rows, based on a time attribute should be deleted (I like to do it without counting the rows). Regards, Iftikhar -- View this message in context: http://www.nabble.com/Table-space-size-tp16040486p16040486.html Sent from the monetdb-users mailing list archive at Nabble.com.
Iftikharn wrote:
Hi
How to check that how much space a particular table has taken or what is the current size of a given tables in bytes etc.
Because I am interested in writing a trigger when a particular table reaches a given size then the oldest of all rows, based on a time attribute should be deleted (I like to do it without counting the rows).
counting is extremely cheap
Regards,
Iftikhar
participants (2)
-
Iftikharn
-
Martin Kersten