Re: Bad query performance after lots of updates

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 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