I've built an appsheet app against a postgresql cloud sql instance. When more than three or four users use the app simultaneously I run out of database connections. My instance has 100 max connections and when this happens, there's one or two active connection and over 90 idle connections. The database is not large yet (12k rows, 22 tables). The cloud sql instance has plenty of memory/cpu resources left.
Does anyone know if it's possible to configure a connection pooler with Appsheet/Postgresql? Is there any documentation out there about best practices for configuring postgres with appsheet? I've read the main help page... no info there, and I didn't find any useful info in prior posts.
The only option I currently see is to shorten the idle connection timeout, but I'd rather make appsheet re-use an open connection. This app is supposed to scale to support 100's of users.
LinkedIn
Twitter
