Postgres sucks. It does a little bit of everything, but badly and with much manual intervention.
I've come to this conclusion too. It's a bit disappointing. I fully realize this is more than likely just user error. And now with AI agents the maintenance of a Postgres instance is likely less of a burden. But I can't help but yearn for the simplicity of a single SQLite file and bespoke solutions for things like queues, pub/sub, caching, etc.
Wild statement, imo. There is no better open source database, so I'm very curious what you prefer and what your use cases are...