Re: slowdown after delete

I am quite sure it is a ‘delete’ related problem, I have done tens of tests. Running queries before the delete is fine, and right after deleting I experience the slowdowns. This happened consistently every time I tested. I have not tried to reboot in between these tests, since we are trying to put the system in production, having to reboot the server whenever we delete some rows would be unfortunate. There must be some other solution.. Stefano

On 20 Sep 2016, at 17:04, Yves Dorfsman wrote:

On 2016-09-20 08:38, Stefano Fioravanzo wrote:

...

Inserting new rows in the table does not present the issue. Moreover if I dump and restore the table after the delete, everything’s back to normal and the queries execute fast.

What about stopping / starting monet? Do you get your performance back?

I had one issue, ~ 350 M rows which I deleted completely and re-imported a few times, and it was slow. At some point later I had to reboot the machine and performance were normal. A lot of other things happen in between, so it might not the be delete.

-- http://yves.zioup.com gpg: 4096R/32B0F416

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list