Connection poolers | Postgres.FM 054 |

Рет қаралды 1,166

Күн бұрын

Nikolay and Michael celebrate the podcast's 1 year anniversary by going through several questions and suggestions received over the year.
Here are some links to some things they mentioned:
* max_connections www.postgresql.org/docs/curre...
* Improving Postgres Connection Scalability: Snapshots (blog post by Andres Freund) techcommunity.microsoft.com/t...
* PgBouncer github.com/pgbouncer/pgbouncer
* Odyssey github.com/yandex/odyssey
* PgCat github.com/postgresml/pgcat
* Adopting PgCat: A Nextgen Postgres Proxy www.instacart.com/company/how...
* Supavisor github.com/supabase/supavisor
* pgagroal github.com/agroal/pgagroal
* PgBouncer is useful, important, and fraught with peril (blog post from JP Camara) jpcamara.com/2023/04/12/pgbou...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
~~~
This is the uncut version, with video. Check out Postgres.fm to find audio-only podcast episodes, edited for convenient listening.

Пікірлер: 7

@IgorDomshchikov 11 ай бұрын

Hi there! Thank you for sharing the video - it was helpful. I have a question about using Hikari CP and PGPool II simultaneously. I am currently using the Hikari connection pool for my Spring application with a Microsoft SQL Server database. However, I am now migrating to a PostgreSQL database with a configured Pgpool ||. During testing, I encountered Connection attempt timed-out issues. Do you have any advice on whether I should use only one of the pool technologies for optimal performance? Thank you in advance for your help.

@NikolaySamokhvalov 11 ай бұрын

Cannot advise on pgpool - I don't use it, don't plan and usually don't recommend using it (revisited this decision a few times for various customers and each time pgpool didn't work well to solve the task). (HikariCP is exactly what I meant when talking about Java at 5:33, btw!)

@IgorDomshchikov 11 ай бұрын

@@NikolaySamokhvalov , thanks for your response. I am having a similar situation when the app nodes scaled up without decreasing the App pooler's number of connection parameter. This may be one of the problems of inconsistency in the load testing results. At kzfaq.info/get/bejne/bJdlnLJkxLmliKs.html, the point to solve the connections overhead issue is to make sure the App pooler has the optimal number of connections? Or instead of App pooler switch to DB pooler that should do that job?

@NikolaySamokhvalov 10 ай бұрын

DB pooler solves it (not necessarily a switch, can be an additional pooler) otherwise, we need to have a requirement that sum of all pool sizes for all app-side pooler must not exceed some constant

@sebschrader 7 ай бұрын

I'm curious why pgpool-ii hasn't even been mentioned

@NikolaySamokhvalov 7 ай бұрын

Because in my opinion, it's Jack of all trades, master of none. This is based on my experience as well as feedback from many people whose opinion I value a lot.