Just testing a create in Singapore myself, I do note that you’ve created a new database which is in a different region to your webservices, so prompting your next question - that’s not possible. We don’t have cross regional network access yet.
Also, Service specific questions might be best served by contacting us directly from Dashboard (Contact Support Link at the very bottom)
Thanks John, are you able to tell us which cloud infra provider Render’s Singapore region is running on? We’d like to colo our hosted database instance with the same provider in the same region to minimise latency.
As a point of feedback: the reason we’re not able to use Render’s PostgreSQL offer is due to the relatively miniscule connection limit even with the largest instance size. Each instance of our app has a maximum connection pool of 100 and we have half a dozen instance running at a time so that’s a maximum of 600 connections under peak workloads. We’re running this many connections off of a meagre 16GiB RDS instance right now.
Are you able to provide some insights to why even the “Contact Us for Custom Plan” caps out at 397 connections? This seems like an oddly low connection ceiling for real workloads on PostgreSQL servers with 16GiB of RAM or more .
Have you considered deploying pgbouncer to better manage your connection pooling, often at these connection counts it works wonders, there’s really no need to have a Postgres service capable of that many connections.
Even if you look at services like Heroku and their massive fleets of Postgres, they’re topping out at 500 connections even on their MASSIVE 768GB plan!
A connection pooler is a vital part of any high-throughput database system, as it eliminates connection overhead and reserves larger portions of memory and CPU time to a smaller set of database connection, preventing unwanted resource contention and performace degradation.