title

text

Sergey Novikov
Sergey Novikov 1 CUPIS
12:05 25 October
90 min

Implementing partitioning without downtime

The built-in partitioning mechanism in PostgreSQL has been developing for several years. However, there is no magic button that would transform an ordinary table into a partitioned one. I will explain how to implement partitioning in a production system, how to prepare your table and apps for partitioning, and what pitfalls can make a DBA's life harder. We will also take a deep dive into various techniques of transferring data between partitions, also considering their pros, cons and limitation.

Slides

Video

Other talks