pgagroal
spqr
| pgagroal | spqr | |
|---|---|---|
| 2 | 5 | |
| 650 | 692 | |
| 0.9% | 18.9% | |
| 7.9 | 9.7 | |
| 6 days ago | 2 days ago | |
| C | Go | |
| BSD 3-clause "New" or "Revised" License | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pgagroal
- Pgagroal: High-performance connection pool for PostgreSQL
-
Scalable PostgreSQL Connection Pooler
I'd be happy to help tuning Odyssey to someone who will bachmark both poolers (in fact there's only one number - number of worker processes..well, maybe pool_size too).
pgagroal claims performance superiority over all poolers [0]. I doubt that Odyssey was used in transaction pooling mode in those experiments.
[0] https://github.com/agroal/pgagroal/blob/master/doc/PERFORMAN...
spqr
- SPQR 1.3.0: a production-ready system for horizontal scaling of PostgreSQL
-
Scalable PostgreSQL Connection Pooler
Transaction poolers are looking on ReadyForQuery packet and it's "in trnsaction" property like this [0]. All you need - is stick server connection on new ParameterStatus[1] packet for "SET search_path" instead of ReadyForQuery.
[0] https://github.com/pg-sharding/spqr/blob/358f816cd8a964a9c9e...
What are some alternatives?
pgbouncer-fast-switchover - Adds query routing and rewriting extensions to pgbouncer
odyssey - Scalable PostgreSQL connection pooler
catfs - Cache AnyThing filesystem written in Rust
AqualinkD - Daemon to control Jandy Aqualink RS pool equipment from any home automation hub (Alexa, Homekit & Siri, Home Assistant, smartthings, domoticz etc) or web browser.
goofys - a high-performance, POSIX-ish Amazon S3 file system written in Go
sgr - sgr (command line client for Splitgraph) and the splitgraph Python library