20 Sep
2016
20 Sep
'16
3:04 p.m.
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