Photo

Horizontal scaling of PostgreSQL with SPQR

Denis Volkov

from Yandex Cloud (Belgrade, Serbia)

About speaker

Code typer

About speakers company

I am developing Managed PostgreSQL service in the Yandex cloud

Abstracts

specific

PostgreSQL is awesome, but it's hard to manage a single database with some terabytes of data and 105+ queries per second. Current sharding solutions focus on analytical and hybrid workloads (OLAP, HTAP).

SPQR is an open-source production-ready system for horizontal scaling of PostgreSQL via sharding, written in Golang. In this talk, I'm going to discuss design decisions that led us through FDW-based sharding, CustomNode-based sharding, C-implemented lightweight query routing, and finally to SPQR design.

The talk was revoked

other talks of this topic