film42 / pgreba

A health-checking service for postgres
2 stars 5 forks source link

Query should use context with a strict timeout #31

Open film42 opened 2 years ago

film42 commented 2 years ago

I don't have hard data to show that this is happening, but we have seen steep resource accumulation when the database is running hot. I wonder if this is a result of long query processing. I think it would be good to limit connect times and query times with a deadline context. Most (if not all) existing query points have a context variant.