Flexible postgres connection limits?

1

The flexible plans seem great but can you give any insight into the connection limits for various configurations? I’d assume there’s an equation to determine what the connection limits would be relative to available RAM so I’d love to see that or figures given in the example configurations in the flexible postgres plan docs.

2

Ah, I just read the general Postgres docs which lays out the memory thresholds for the 3 connection limit tiers. Are those the same on flexible plans? Not clutch but if so that would be a nice note to have in the docs/the plan upgrade stat panels as a quick reminder.

3

Hi there,

I will pass this feedback on to our UX team. Having the connection limit listed on each plan when upgrading the service through our dashboard seems reasonable.

Regards,

Keith
Render Support, UTC+10 :australia:

4

Thank you! Similarly, when you have swapped to the new flexible plans and attempt to upgrade and choose a storage amount, there are a couple of quirks:

  1. The storage amount has a minimum of 1 gb and comes in 5gb chunks. Which implies that the levels are 1gb, 6gb, 11gb, 16gb, etc. but the actual valid choices seem to be 1gb, 5gb, 15gb, 16gb… etc?. Those give valid prices, all others give a price of $-1. So I’m assuming the logic is that storage levels of 1gb, modulus 5 == 0, and legacy are the actual valid choices, which seems to me like it should be a select or broken into 1gb chunks. Regardless the text input seems brittle.
  2. I just upgraded to an accelerated plan with 16gb of RAM and the connection limit is 403 on the db metrics page. As far as I can tell this doesn’t match any spec I’ve seen in the docs, so, not ideal since it’s significantly lower than any of the docs specify as far as I can tell. This one stings a bit, I’m deploying a site that will have a big initial push soon and 400 vs 500 connections is a pretty big difference.
  3. I also upgraded to 25gb of storage since that’s one of the options that gave a valid price, but the instance info says I’m using X% of 24gb of storage while my instance type specifies 25gb.
5

Hi there,

  1. The storage section looks okay to me. I’m not seeing $-1 if I enter an invalid value. It will tell you it must be in increments of 5GB.

  2. The metrics page does list 403 connections for a 400-connection service. 3 connections are reserved for superuser connections. Your actual limit is still 400. A 500-connection service will have 503 on the metrics page, and a 100-connection service will have 103 connections. I’ll mention this difference to our team.

  3. Can you open a ticket directly with us using the Contact Support link in our dashboard? My services should have the correct storage value. We would need to look at your specific service to see why this value is incorrect.

Regards,

Keith
Render Support, UTC+10 :australia:

6

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.