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