25–29 Apr 2022
Europe/Zurich timezone

Introducing PostgreSQL Table Partitioning to Dcache

27 Apr 2022, 17:55
25m
Online workshop

Online workshop

Storage & Filesystems Storage & File Systems

Speaker

Mwai Karimi

Description

Database systems have been known to deliver impressive performance for large classes of workloads. Nevertheless, database systems with mammoth data sets or high throughput applications can challenge the capacity of a single server. High query rates can exhaust the CPU capacity of the server and having working set sizes larger than the system's RAM stresses the I/O capacity of disk drives. This presentation will show how we use postgres table partitioning to take the edge off some of these issues to improve performance.

Speaker release Yes

Authors

Christian Voss Mwai Karimi Tigran Mkrtchyan (DESY)

Presentation materials