PgCat can parse queries, detect sharding keys automatically, and route queries to the correct shard. Mirror queries between multiple databases in order to test servers with realistic …

PgCat is PostgreSQL connection pooler and proxy which scales PostgreSQL (and PostgresML) databases beyond a single instance. It supports replicas, load balancing, sharding, failover, …

2024年8月15日 · PgCat利用Tokio异步框架的多线程实力，为PostgreSQL提供了更为高效的连接管理和负载均衡能力。 它支持从简单的会话到复杂的事务处理，以及读写分离和自动故障转移 …

pgcat是一个类似于pgbouncer 的连接池，并且共享它工作的部分逻辑方式，但它有一个根本的区别：它允许为单个客户端连接使用多个数据库。 pgbouncer 只会将客户端连接到单个数据库。 …

PgCat offers many features out of the box, and comes with good default values for most of its configuration options, but some minimal configuration is required before PgCat can start …

PgCat has many features currently in various stages of readiness and development. Most of its features are used in production and at scale. PgCat can automatically load balance Postgres …

2024年11月11日 · PostgreSQL pooler with sharding, load balancing and failover support. - Releases · postgresml/pgcat.

2024年5月24日 · pgcat是一款基于PostgreSQL的逻辑解码技术构建的增强型工具，旨在扩展其逻辑复制功能。 pgcat不仅支持基本表作为复制目标，还能够处理视图、外部表、分区表甚 …

2022年11月14日 · pgcat is a connection pool like pgbouncer, and shares part of the logical way it's working, but it has a fundamental difference: it allows to use multiple databases for a single …

# `pg_bigint_hash`: PARTITION BY HASH (Postgres hashing function) # `sha1`: A hashing function based on SHA1. sharding_function = "pg_bigint_hash" # Query to be sent to servers …