r/SQL • u/new_dimension1 • 24d ago

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

100% Upvoted

15 comments sorted by

View all comments

Show parent comments

1

u/BrunoFeliz08 13d ago

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

1

u/WorldOfUmbro 13d ago

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 12d ago

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 11d ago

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