Limit Postgres max / idle connections

[BoxBoxJason]

Limit Postgres max connections

Problem definition

I am running a self hosted instance with a docker setup, and a remote database.
For resources optimization (and constraints), I prefer setting a lower number of db connections for each app. So I set the limit to 2 (on the postgres server) because solidtime is supposed to have a very low throughput in my case.

Most of the time the app runs fine, but there is an error bubble that keeps showing up (every 10 seconds): The action failed. Please try again later. on the UI.

Also in the browser console I keep seeing 500 errors and uncaught exceptions

Uncaught (in promise) Error: Failed to handle API request
    n notification.ts:90
    I pinia.mjs:1399
    n useTags.ts:14
    I pinia.mjs:1399
    O init.ts:17
    onfocus AppLayout.vue:94
    setTimeout handler*setup/</window.onfocus AppLayout.vue:91

Suggestion

On most apps, there are two options that can be used:

• to limit the maximum number of db connections that can be opened, usually DB_MAX_OPEN_CONN defines it.
• to limit the maximum number of idle db connections that can be kept, usually DB_MAX_IDLE_CONN defines it.

I tried to look around but unfortunately I could not find anything about that in the documentation. Maybe it's already possible but is just missing documentation.

Could this be implemented & documented ?