Daniel Farina 318904934e Change linear scaling of Postgres max_connections to a constant ...

This creates difficult problems with hot standby, since a database
cannot enter hot standby without an equal-or-larger `max_connections`
to size some shared memory arrays that permit the system to answer
queries.  Warm standby is still operable, though.

Also, larger database sizes will calculate excessively large
`max_connections`, e.g. 6000, that slow down snapshot acquisition.

Now it is set to 500, a value that seemed okay in the previous decade
or so over several services.  Though, occasional customers did need
custom settings, and the service needed to grow an awareness of how to
set `max_connections` on standbys based on the parent's setting(s)
over time.

This will have some implications on existing databases adding HA
standbys (in that, they will fail), but producing more databases with
very large connection counts is likely a worse outcome.

2025-02-13 14:13:56 -08:00

8.2 KiB

Raw Permalink Blame History

View Raw