PostgreSQL on Ubuntu could be improved with easier out-of-the-box configuration. The default settings for PostgreSQL on a fresh Ubuntu install are very conservative. Things such as shared buffers and work memory are too low for any real production workloads, and you have to know how to go in and tune it manually. A smart default configuration wizard during installation that detects hardware and suggests settings would save a lot of junior developers from performance headaches. That is important. Built-in connection pooling is another area; PostgreSQL does not handle large numbers of concurrent connections well natively. You end up needing to set up PG Bouncer separately, which is another tool to learn, configure, and maintain. Having a lightweight connection pooler built into the core installation would be a real quality-of-life improvement. Additionally, a better built-in monitoring UI would help. Primarily, if you are working with Ubuntu, you are largely working with PostgreSQL on the command line and installing third-party tools such as pgAdmin or Adminer. A lightweight built-in web dashboard for basic health monitoring would improve projects significantly. Finally, upgrades between major versions and smaller versions should be a lot easier as well. None of these are deal-breakers; they are just nice to have improvements.
