3 ms·
Are there benchmarks comparing this to Hikari? What is the benefit to using this over Hikari?
by haggy 7y ago
Are there benchmarks comparing this to Hikari? What is the benefit to using this over Hikari?
- clhodapp 7y agoThis is an external pool, rather than an internal one. That is to say that it runs as a separate process that re-implements the Postgres network protocol to accept incoming connections. The use-case is that it allows you to share one pool across multiple application processes. Depending on your architecture, it can actually make sense to use both an internal pool to reduce connection startup latency and an external pool to reduce your total number of connections.
- manigandham 7y agoHikari is a Java ODBC connection pooling library, meant to be used in your apps. Most other languages/frameworks also have client drivers that implement connection pooling today, but that only affects that specific program. Odyssey / PGBouncer / PGpool are all external programs that implement connection pooling so multiple programs and servers can pool connections to a single database.