Retool run multiple query

luan_d_ng · June 5, 2023, 11:18am

I have more then 40 queries run on load page and i got this error

How can i avoid this error?

Kabirdas · June 12, 2023, 4:51am

Because of how requests are routed on the backend it's possible that separate queries can create new connections to your database. If you're running into the maximum number of connections you can try either increasing the max_connections setting on your database or using something like PgBouncer to implement connection pooling.

Where are you hosting your Postgres database?

luan_d_ng · August 4, 2023, 1:35am

i'm hosting it on supabase

Kabirdas · August 13, 2023, 11:12pm

It looks like Supabase integrates with PgBouncer! There's a blog post on it here and hopefully that works. Is it something you had investigated already?

oschmitt · August 16, 2023, 5:45pm

@Kabirdas Hi! Does pgBouncer also integrate with the Retool DB? I'm having the same error

Kabirdas · August 24, 2023, 2:43am

Hey @oschmitt! This may be related to a backend issue seen by certain users on RetoolDB and we've been in the process of migrating a large number of orgs to a new DB provider so that it won't occur. Yours should now be moved over as well, can you let me know if you're still running into the error?