Maksim Milyutin
Programmer @ Postgres Professional
Ulyanovsk

Distributed sharding in PostgreSQL using pg_pathman (master class)

  • Auditorium: SOVIET SCHOOL
  • Category: Development
  • Section: Database

Description:

Foreign Data Wrapper implementation enables sub-querying remote data sources within the current query. Combined with sharding (using pg_pathman, in particular) this engine allows a distributed store of large tables mostly for hard-case analytic queries.

As part of the master class, this report will demonstrate such a way of a horizontal partition of data in a database, and compare it with the sharding solutions available in PostgreSQL.


О спикере

Maksim Milyutin

Programmer @ Postgres Professional
Ulyanovsk

Developer at Postgres Professional. The author of pg_query_state plugin. Currently engaged in pg_pathman development, a plugin for PostgreSQL / Postgres Pro that enables a fast and efficient table sharding, and contributing to a vanilla PostgreSQL sharding.

Похожие доклады