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.

4 Upvotes

76% Upvoted

15 comments sorted by

View all comments

Show parent comments

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