postgresql database use 100% cpu after restart container.

[ghost]

my cardano rosetta docker container cause high disk io, after I restart docker container. cardano-node worked well, but /network/status cann't get latest block.

I attach into the container, find postgres use 100% cpu. Querying sql is DELETE FROM "block" WHERE "id"=3160744, which has run for more than 1 hour.

If you need any log file to diagnose, I'm glad to help.

[rhyslbw]

What is your host machine spec?

[ghost]

What is your host machine spec?

2 core 8G memory, usually there will be 4G free memory left.

[AlanVerbner]

@rhyslbw could this be related to db-sync rolling back the data to the previous epoch?