0

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.

  • 3
    It has been days, and you didn't even look into the log file? Besides, what kind of problem description is "stops working"? – Laurenz Albe Nov 25 '22 at 06:35

0 Answers0