I am using Postgres for DB and have a big table (+10.000.000 rows inside). When I run the update query (update table set field=1 where id in ("maximum 2500 id I put there")) my system stops working. I put Grafana monitoring to check which parameters go up on DB Server but seems all good there.
Can someone help me with the idea what can be the reason? For days I am not able to understand what's happening.