The problem is that I am having ~70M rows in a table, but its bat storage size is showing 170M rows. Although the count * still returns 70M, but memory is increasing very heavy each day. As described in previous mail, each day, ~1M rows are deleted from table and ~1.1M added, but it actually increases the size by 1.1M.

Please let me know if something wrong in this way of updation of monetDB tables.

Regards,

manish

On Sat, Mar 25, 2017 at 2:05 PM, Manish gupta <gahoimnshg@gmail.com> wrote:

Dear All,

    Is there a way to truncate the table size when deleting some of the records? In my application, I delete and insert ~1 million records daily. But effectively, it should result in few hundreds additional records. But, I see the size of the table increases by a millions ( that can be seen in storage(), as well as hard disk size ). While the "select count(*) from table"  reflects correct number. Is there a way, I can stop increase in table size in my scheme?

Regards,

Manish