Hangfire icon indicating copy to clipboard operation
Hangfire copied to clipboard

High database CPU usage (postgres)

Open dario-hd opened this issue 4 years ago • 1 comments

We noticed that the top queries executed on our DB cluster on production are from hangfire:

image

The CPU usage from hangfire it's almost the same as our whole platform. Is there a way to tweak these queries? Maybe we can adjust the parameters in order not to be executed so often? Also, have you considered redirecting read-only queries to read-only replicas by allowing specifying 2 different connection strings?

What are your suggestions?

dario-hd avatar Feb 16 '22 14:02 dario-hd

Also, have you considered redirecting read-only queries to read-only replicas by allowing specifying 2 different connection strings?

Very interested in this as well.

rblaine95 avatar Apr 09 '24 06:04 rblaine95