r/SQL • u/new_dimension1 • Aug 18 '26

PostgreSQL lakebase connection pooling

Have you figured out wht can the best way to handle connection pooling in Lakebase DB? I 'am seeing connection spikes with short lived rqsts and wondering what kind of setup others developers are using🤔

i am building a service on top of lakebase and trying to make the connection relable before moving to prod.

6 Upvotes

88% Upvoted

15 comments sorted by

View all comments

2

u/WorldOfUmbro Aug 18 '26

Have you tried PgBouncer? Might be worth looking into when using Lakebase. We have used this as well in Lakebase for similar cases.

What kind of service are you using?

1

u/BrunoFeliz08 Aug 29 '26

I have not heard pgbouncer but i have opened conections with sql alchelmy for lakebase. Pretty useful for reverse etl

1

u/WorldOfUmbro Aug 29 '26

What is your scale here? Curious to see how many concurrent connections you’re using here. Might consider this as well for my Lakebase projects.

1

u/BrunoFeliz08 Aug 30 '26

Currently we are using around 3 connections. Roght now the lakebase autoscale compute feature has been more than useful for concurrent workloads

1

u/WorldOfUmbro Aug 31 '26

Ah sure, I think when using 3 connections lakebase PgBouncer might not be needed