this post was submitted on 24 Jun 2024
32 points (97.1% liked)
Lemmy Support
4622 readers
23 users here now
Support / questions about Lemmy.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
I have. It's running postgres v16.3
Sometimes after upgrades, even minor ones, I find it useful to run analyze on all of the tables. I usually do
analyze verbose;
so I can see which tables are getting analyzed. This will assess every table so the query planner can make better decisions about how to resolve queries. If the query planner is making bad decisions I/O and CPU will be high and query performance will be poor.Thanks. I ran it. Hopefully it'll make a difference.
Edit: It looks like this did the trick. I'll keep monitoring to see if it sticks. Thanks again!