I find it increasingly difficult to self-host a #PostgreSQL database and have full confidence that it runs in a fully optimized way. There are so many settings, many targeting the underlying VM/hardware. Often I don’t even have enough information about the VM/hardware to know what the most optimal settings are.
PostgreSQL devs are adding tons of new features and settings with every release.
There should be a lightweight “auto” mode where PG figures out the most appropriate settings with only a few hints.
But PG is now an enterprise RDBMS primarily targeting Oracle customers. Simplicity is not a quality they expect and I understand that.
I think it is time to explore the #SQLite route as an alternative. There is https://rqlite.io a fault-tolerant distributed SQLite server with an HTTP API written in Go, with automatic S3 backup and restore.