​
What is SPQR

SPQR (Stateless Postgres Query Router) is a production-ready system for horizontal scaling of PostgreSQL via sharding.

​
Why SPQR

PostgreSQL is awesome, but it’s hard to manage a single database with some terabytes of data and 105+ queries per second. Existing sharding solutions focus on analytical and hybrid workloads (OLAP, HTAP). Moreover, most of those solutions do not provide a simple, painless path for the monolith <-> sharded transitions. That’s why the
Data Platform team of Yandex.Cloud designed SPQR.

Our team has been exploring different approaches to sharding a PostgreSQL cluster for a long time. We have considered FDW-based sharding, CustomNode-based sharding, C-implemented lightweight query routing, and finally came to the SPQR design.

SPQR is a good fit for:

  • Developers who are comfortable with Postgres and prefer not to use other database engines
  • Developers who cannot or do not wish to implement sharding logic on the application level
  • A database that is well splitted by a sharding key
  • Single-shard OLTP queries

Get started

Start sharding your PostgreSQL cluster in 5 minutes

Internals

Learn more how SPQR works under the hood

Features

Main SPQR features

Configuration

The complete Configuration reference

Was this page helpful?

Get Started