Hi,
select count(*) from table where field = 'some value'; --> a few ms
update table set field = 'value'; --> update 2 million rows out of 1 billion rows
select count(*) from table where field = 'some value'; --> almost a minute :(
Analyze did not help and sys.vacuum could not be used as the table has indexes (foreign key).
Re-starting the DB helped ;)
What's the recommended way to make MonetDB perform well after lots of updates?
Kind regards, Daniel
Hai Daniel,
Does the fix for https://www.monetdb.org/bugzilla/show_bug.cgi?id=6941 https://www.monetdb.org/bugzilla/show_bug.cgi?id=6941 help solve this problem as well?
In Jun2020, we have introduced "negative candidates" list, which should considerably speed up select queries after deletes. Maybe we overlooked something...
Regards, Jennie
On 27 Aug 2020, at 17:21, Daniel Glöckner gloeckner.daniel@gmail.com wrote:
Hi,
select count(*) from table where field = 'some value'; --> a few ms
update table set field = 'value'; --> update 2 million rows out of 1 billion rows
select count(*) from table where field = 'some value'; --> almost a minute :(
Analyze did not help and sys.vacuum could not be used as the table has indexes (foreign key).
Re-starting the DB helped ;)
What's the recommended way to make MonetDB perform well after lots of updates?
Kind regards, Daniel
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Daniel Glöckner
-
Ying Zhang