Re:Things I hate about PostgreSQL (2020)
by brianwawok on Tuesday April 06, 2021 @09:38AM
(#26711580)
It's pretty hard to fix a complex black-box query planner with an estimate of when another black box analyze command will fix it.
That said, if you have good monitoring, you can hopefully find out when a query gets hosed and at least have a chance to fix it.. it's not terribly often.
That said, if you have good monitoring, you can hopefully find out when a query gets hosed and at least have a chance to fix it.. it's not terribly often.