lowdefy icon indicating copy to clipboard operation
lowdefy copied to clipboard

Using Postgresql lowdefy seems to just create new connections and never close idle ones.

Open cyborg-x1 opened this issue 1 year ago • 1 comments

Describe the bug

Connections to Postgresql seem to be kept idle, while new connections are created.

To Reproduce

Use Postgresql requests and access the system with many users. At some point there should be the error that there are to many connections for Postgresql.

Solutions

Set database connection timeout to something like 10 seconds, increase maximum connections. So postgesql terminates idle connections. If many users accessing this still might lead to too many connections.

Lowdefy Version

3.23.3

cyborg-x1 avatar Mar 01 '23 15:03 cyborg-x1

https://github.com/lowdefy/lowdefy/discussions/1370

Gervwyk avatar Sep 01 '23 16:09 Gervwyk