[jauntywundrkind]

Very memorable post about this happening at Bluesky, about being utterly unable to trust Postgres to keep doing what it's doing.

> Bluesky scaling lesson: Postgres is not a great choice if your data can be irregular.

> The query planner will switch over to a new plan that consumes 100% CPU in the middle of the night whenever its table stats flip the heuristics the wrong way.

> Postgres badly needs query hints like MySQL has!

https://bsky.app/profile/jacob.gold/post/3kn4v67wyjt2l