Remove articles database-connection-pooling-with-pgbouncer
article thumbnail

Schema-based sharding comes to PostgreSQL with Citus

The Citus Data

Citus, a database scaling extension for PostgreSQL, is known for its ability to shard data tables and efficiently distribute workloads across multiple nodes. introduced a citus.enable_schema_based_sharding setting that allows you to shard your database based on schemas. this schema-based sharding approach may be significantly easier!

article thumbnail

Analyzing the Limits of Connection Scalability in Postgres

The Citus Data

One common challenge with Postgres for those of you who manage busy Postgres databases, and those of you who foresee being in that situation, is that Postgres does not handle large numbers of connections particularly well. last year in the Azure Database for PostgreSQL. Why connection scalability in Postgres is important.