PgCat, Postgres pooler with sharding, load balancing and failover
PostgreSQL pooler with sharding, load balancing and failover support. - postgresml/pgcat
PgCat, Postgres pooler with sharding, load balancing and failover launched on February 9, 2022 with 233 votes, #104 of 2,645 launches that month and more than 95% of that year's launches. The site was still online in September 2026, 4 years on.
In plain words
PgCat is a Postgres connection pooler that manages database connections while adding sharding, load balancing, and failover capabilities. It is designed for developers and database administrators who need to scale PostgreSQL databases across multiple servers and handle traffic distribution. The tool stands out by combining connection pooling with automatic failover, allowing databases to remain available even when individual servers fail, while distributing queries across multiple instances.
written from the facts on this page · September 2026
Does a similar job
all alternatives →
PgDog – Scale Postgres without changing the appFeb 2026 · github.com · ▲326Hey HN! Lev and Justin here, authors of PgDog (https://pgdog.dev/), a connection pooler, load balancer and database sharder for PostgreSQL. If you build apps with a lot of traffic, you know the first thing to break is the database. We are solving this with a network proxy that works without requiring application code changes or database migrations. Our post from last year: https://news.ycombinator.com/item?id=44099187 The most important update: we are in production. Sharding is used a lot, with direct-to-shard queries (one shard per query) working pretty much…
Supavisor – a Postgres connection pooler written in Elixir2023 · github.com · ▲149hey hn, supabase ceo here this is a postgres connection pooler. it’s similar to pgbouncer, but built with Elixir and specifically designed for multi-tenancy. it’s still under development, but it’s at a stage where we can gather a feedback from the community and you can try it yourself. we aren’t using this in production yet, but aiming to deploy it for a subset of databases in the next 2 months. We have the following benchmarks (details in the readme): - Elixir Cluster maintaining 400 connections to a single Postgres database - 1_000_000 clients connecting to the Elixir cluster - Sending…
PgQueuer – Transform PostgreSQL into a Job Queue2024 · github.com · ▲376PgQueuer is a Python job queue that uses PostgreSQL for everything — queue storage, locking, notifications. No Redis, no RabbitMQ, no separate broker to operate. If your app already has Postgres, you already have the broker. After ~2 years and 26 minor releases, 1.0 ships today as the first stable release. Strict semver from here on. Thanks to everyone who contributed and left feedback!
pg_flame – flamegraph visualizations of PostgreSQL query plans2019 · github.com · ▲321A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame
Pg_replicate – Build Postgres replication applications in Rust2024 · github.com · ▲216A high-performance Postgres replication engine written in Rust. Embed it in your Rust application or run it as a standalone binary. - supabase/etl
Questions this answers
More life & fun this month
the category →
A free city-building game in your browser. You are the mayor. You know what the city needs. Now get it past the zoning board, the neighbors, the appeals court and the next election.
Life & fun · 22h ago · permit.petercai.com
- IV
Life & fun · 13d ago · tanzaniaeducationproject.org
Turn a phone, tablet or TV into a sign. Type a message and it fills the screen: welcome signs, timers, Wi-Fi passwords and more. No app, no account, free.
Life & fun · 14d ago · bigwords.page
Play a free virtual guitar online with your keyboard or by touch. Slow songs down and see every chord, string and strum. Acoustic, classic, electric and bass.
Life & fun · 8d ago · guitoro.com
Carrier settings from iPhone, Pixel and Galaxy firmware, decoded and compared: APNs, VoLTE, 5G and Wi-Fi Calling per carrier, and what each build changed.
Life & fun · 12d ago · carrierexplode.com
Life & fun · 22d ago · space.bl2.net
Source: Show HN post ↗
Launched alongside, February 2022
the whole month →
Sha256 algorithm explained online step by step visually
Life & fun · 2022 · sha256algorithm.com
EdgeDB 1.0▲947Today, after years of research, development, and refinement EdgeDB graduates to a production-ready database. We are very proud to announce EdgeDB 1.0.
Dev tools · 2022 · edgedb.com
