31. PostgreSQL Scale

Date: 2024-01-11

Status

Accepted

Context

We need to have a strategy for scale PostgreSQL.

Decision

We have seen these options:

• Hardware
  • Network-attached block storage
• LoadBalancer
  • PGBouncer - Lightweight connection pooler for PostgreSQL.
• Replication
  • Read replicas
  • Active-active
• Partitioning
• Sharding (Transparent sharding)
  • Citus - Citus is an open-source extension to Postgres that transforms Postgres into a distributed database.

Type of load:

• OLTP - Online Transaction Processing
• OLAP - Online Analytical Processing
• HTAP - Hybrid Transactional/Analytical Processing

Consequences

We have a strategies for scale PostgreSQL.

References

• An Overview of Distributed PostgreSQL Architectures