spqr vs pgagroal

spqr

Stateless Postgres Query Router. (by pg-sharding)

Go Postgresql Sharding

Source Code

Suggest alternative

Edit details

pgagroal

High-performance connection pool for PostgreSQL (by agroal)

Postgresql High Performance Connection Pool

Source Code

agroal.github.io

Suggest alternative

Edit details

InfluxDB - Power Real-Time Data Analytics at Scale

Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

www.influxdata.com

featured

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com

featured

spqr		pgagroal
	Project
5	Mentions	2
685	Stars	650
18.1%	Growth	0.9%
9.7	Activity	7.9
5 days ago	Latest Commit	5 days ago
Go	Language	C
GNU General Public License v3.0 or later	License	BSD 3-clause "New" or "Revised" License

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.

spqr

Posts with mentions or reviews of spqr. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-03-25.

SPQR 1.3.0: a production-ready system for horizontal scaling of PostgreSQL
5 projects | news.ycombinator.com | 25 Mar 2024
Scalable PostgreSQL Connection Pooler
11 projects | news.ycombinator.com | 12 Nov 2021

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...

pgagroal

Posts with mentions or reviews of pgagroal. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-11-12.

Pgagroal: High-performance connection pool for PostgreSQL
1 project | news.ycombinator.com | 21 Nov 2021
Scalable PostgreSQL Connection Pooler
11 projects | news.ycombinator.com | 12 Nov 2021

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...

What are some alternatives?

When comparing spqr and pgagroal you can also consider the following projects:

pgbouncer-fast-switchover - Adds query routing and rewriting extensions to pgbouncer

catfs - Cache AnyThing filesystem written in Rust

odyssey - Scalable PostgreSQL connection pooler

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