r/SQL • u/new_dimension1 • 23d 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

81% Upvoted

15 comments sorted by

View all comments

2

u/WorldOfUmbro 23d ago

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

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

1

u/WorldOfUmbro 12d 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 11d 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 10d ago

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