This has actually bitten me too, I have to perform a nightly operation of dumping the table, dropping it, re-create the table then batch load all of the data back into it which can take some time.

On Tue, Feb 23, 2010 at 1:47 PM, Martin Kersten <Martin.Kersten@cwi.nl> wrote:
Reeves, Matthew J. wrote:
> Hello,
>
>    I have a MonetDB database that contains a table of rolling events.
> There are 200 million records with 500,000 bulk loaded each day with the
> oldest 500,000 deleted at midnight. I'm finding the database gets slower
> as time goes on. It gets to the point of being almost unusable after a
> week. Is there something I should be doing different?
Hello Matthew,
Thanks for using MonetDB. Interesting application target.

This is a known issue. The system keeps the deleted tuples and rebuilds the table.
A vacuum-like feature is needed and on the wishlist. For now, taking a copy
of the table would 'solve' your problem.

regards, Martin
>
> Thanks,
> Matt
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users


------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users