Fred R.
Fred R.

Reputation: 567

MonetDBLite dir does get smaller after table drop

Every time I drop a table and import new data in a newly create table, the footprint of MonetDBLite keeps getting larger. Is there anything like a sweep I need to do to reclaim the space every time a table is dropped? Here is the snippet I use to drop and import data into tables.

conn <- dbConnect(MonetDBLite::MonetDBLite(), dbdir)
if (dbExistsTable(conn, 'my_events'))
   dbRemoveTable(conn, 'my_events')
monetdb.read.csv (conn, dbdir, 'my_events.csv', 'my_events')

Upvotes: 0

Views: 64

Answers (0)

Related Questions