DoK #58 Benchmarking for PostgreSQL workloads in Kubernetes // Gabriele Bartolini & Francesco Canovai

Abstract of the talk…

Databases like PostgreSQL cannot run on Kubernetes. That’s the refrain we hear all the time, as well as the motivation for us to break this barrier, once and for all. Hear the story of our journey so far about bringing PostgreSQL to Kubernetes. Discover why we believe that benchmarking both the storage and the database before production leads to a healthier and longer experience of the DBMS, even in Kubernetes. We’ll be sharing our process, and the results obtained so far, and unveil our plans for the future.

Bio…

A long time open-source programmer and entrepreneur, Gabriele has a degree in Statistics from the University of Florence. After having consistently contributed to the growth of 2ndQuadrant and its members through nurturing a lean and devops culture, he is now leading the Cloud Native initiative at EDB. Gabriele lives in Prato, a small but vibrant city located in the northern part of Tuscany, Italy - famous for having hosted the first European PostgreSQL conferences. His second home is Melbourne, Australia, where he studied at Monash University and worked in the ICT sector. He loves playing the Blues with his Fender Stratocaster, but his major passions are called Elisabeth and Charlotte!

Francesco is a senior software engineer and member of the EDB Cloud Native team. With a background in system and PostgreSQL administration, he works on automation, CI/CD, testing, and compliance for the Cloud Native PostgreSQL operator.

Key take-aways from the talk…

1. A methodology for benchmarking a PostgreSQL database in Kubernetes 2. Open source set of tools for benchmarking a PostgreSQL database in Kubernetes 3. Reasons why benchmarking the storage and the database is important