I'm an absolute idiot. I forgot to run ANALYZE after upgrading PostgreSQL. No wonder it is doing sequential scans all the time and broke my Matrix server completely.

@PeterCxy ...you likely just saved my day, what a coincidence

Follow

@PeterCxy upgrading everything. monitoring actually looked fine but running ANALYZE is still good practice, just like gentoo users recompiling everything...

@ghost My Mastodon instance also worked fine before ANALYZE because it does not really need that much of index scan to work well. However Matrix is an absolute beast and without index scans it just stalls completely.

Sign in to participate in the conversation
Fairground

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!