Feature Requests

It would be nice to be able to upgrade Postgres version by clicking a button, going through downtime, and then coming back up on the next Postgres major version. The docs currently describe creating a new database and restoring a backup into it: https://render.com/docs/databases#database-versions--upgrades .

Open-source vector similarity search for Postgres https://github.com/pgvector/pgvector Very useful for A.I. applications which is a fast-growing market Render might want to tap into :)

"Currently, we don't support downgrading PostgreSQL instances. Make sure to pick the instance type that works for you." We needed to upgrade in order to get more CPU/memory to prune some records in our sandbox environment so that we can address an approaching storage limit. We'd love to be able to downgrade back down easily to save unnecessary expenses. Thanks!

While Render provides affordable options, there is a huge jump between Standard and Pro tiers. When comparing to Heroku, there is a lot more flexibility to what and how much you want to pay for. For example, someone wouldn't mind upgrading for an additional 20-30GB of storage, which could last them years depending on their use-case. But currently you would have to pay $75 per month for a huge upgrade, which might be 70-80% unutilized, making it not a great financial decision for many users. So in general, just having an additional in-between tier between Standard and Pro options would go a long way. But the more tiers Render could provide, the better

I would like to be able to create a database via API in a way I can create other types of services. Unfortunately, without this the whole API is useless to us.

Automatically promote a follower PostgreSQL instance if/when the primary instance goes down. [1] https://feedback.render.com/features/p/read-replicas-for-postgresql

Would be really helpful if we could initiate making database backups through a database call (so that we can make a backup automatically before a deploy for instance).

Users can benefit from more backup strategies

It's not possible to delete databases using the Render REST API at the moment.

A PGBouncer template would be awesome for easy postgres connection pooling.