4–7 Nov 2019

PostgreSQL at low level: Stay curious

Dmitrii Dolgov (Zalando)
16:4517:25 Wednesday, 6 November 2019
Location: Hall A4
Average rating: ****.
(4.25, 4 ratings)

Who is this presentation for?

  • Database administrators

Level

Intermediate

Description

PostgreSQL does not work in at vacuum; it relies heavily on functionality provided by an underlying platform. And sometimes to answer questions such as tracking down a transient performance issue that’s hard to investigate from a database-only point of view, determining how many layers of abstraction your database is working on, or the difference between running your database on bare metal, VM, or inside a container, you have to step back and look at the problem from a different point of view.

Dmitrii Dolgov takes a deep dive into how to troubleshoot intricate performance issues from a point of view other than database only (e.g., lock preemption problems on VM, shared memory segment limitations, or memory reclaim process within a container) in PostgreSQL using such tools as strace, perf, extended Berkeley Packet Filter (eBPF). And stay curious.

Prerequisite knowledge

  • Familiarity with quantum physics and chess openings (useful but not required)

What you'll learn

  • Learn how to discover a new world of low-level details using strace, perf, eBPF, and bcc
Photo of Dmitrii Dolgov

Dmitrii Dolgov

Zalando

Dmitrii Dolgov is a software engineer at Zalando and a PostgreSQL contributor.

Contact us

confreg@oreilly.com

For conference registration information and customer service

partners@oreilly.com

For more information on community discounts and trade opportunities with O’Reilly conferences

velocity@oreilly.com

For information on exhibiting or sponsoring a conference

pr@oreilly.com

For media/analyst press inquires