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 msupdate table set field = 'value';--> update 2 million rows out of 1 billion rowsselect 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