Talks
Here’s a list of talks I’ve presented on various conferences dedicated to either PostgreSQL or open source in general. Talks that I presented on multiple conferences have several versions - I tend to improve / adjust the talk over time, so there’s no single authoritative version.
2024
The past and the future of the PotgreSQL community, Swiss PGDay 2024 [PDF] [schedule]
Where do the performance cliffs come from, POSETTE 2024 [PDF] [schedule] [YouTube]
Where do the performance cliffs come from, pgconf.be 2024 [PDF] [schedule]
Postgres vs. Linux Filesystems, FOSDEM 2024 [PDF] [schedule & video]
2023
Postgres vs. Linux Filesystems, pgconf.eu 2023 [PDF] [schedule] [YouTube]
PostgreSQL Hacking Introduction, OpenAlt 2023 [PDF] [schedule] [YouTube]
Novinky v PostgreSQL, OpenAlt 2023 [PDF] [schedule] [YouTube]
Novinky v PostgreSQL, LinuxDays 2023 [PDF] [schedule] [YouTube]
BRIN Index Improvements and new opclasses, PGCon 2023 [PDF] [schedule] [YouTube]
2022
BRIN Index Improvements, PostgresLondon 2022 [PDF] [schedule]
Does the data/WAL page size actually matter?, PostgresVision 2022 [PDF] [schedule] [YouTube]
CREATE STATISTICS improvements, pgconf.de 2022 [PDF] [schedule]
2021
2020
2019
CREATE STATISTICS - what is it for?, PostgresLondon 2019 [PDF] [slideshare]
CREATE STATISTICS, pgconf.be 2019 [schedule]
Data corruption - where does it come from and what can you do about it?, Nordic PGDay 2019 [PDF] [schedule] [slideshare]
2018
CREATE STATISTICS - what is it for?, pgconf.eu 2018 [PDF] [schedule] [slideshare]
CREATE STATISTICS - what is it for?, Nordic PGDay 2018 [PDF] [schedule]
Co je nového v PostgreSQL 10 (a 11), Prague PostgreSQL Developer Day 2018 [PDF] [schedule]
2017
2016
Performance improvements in PostgreSQL 9.5 and 9.6, 5432meet.us 2016 (Milan) [PDF] [schedule] [slideshare]
Novinky v PostgreSQL 9.5, Prague PostgreSQL Developer Day 2016 [schedule]
PostgreSQL Performance on EXT4, XFS, F2FS, BTRFS and ZFS, FOSDEM PGDay 2016 [PDF] [schedule] [slideshare]
2015
Performance improvements in 9.5 and beyond, pgconf.eu 2015 [PDF] [schedule] [slideshare]
PostgreSQL Performance on EXT4, XFS, F2FS, BTRFS and ZFS [PDF] [schedule] [slideshare]
Novinky v PostgreSQL 9.4, Prague PostgreSQL Developer Day 2015 [schedule]
2014
Performance Archaeology, pgconf.eu 2014 [PDF] [schedule] [slideshare]
Useful yet frequently omitted extensions, Nordic PGDay 2014 [schedule]
2013
2012
Provoz PostgreSQL na AWS, pgconf.eu 2012 [schedule]
Migrace z MySQL na PostgreSQL, pgconf.eu 2012 [schedule]
Čtení exekučních plánů, pgconf.eu 2012 (školení) [schedule]
PostgreSQL vs. SSD, Prague PostgreSQL Developer Day 2012 [PDF] [schedule] [slideshare]
2011
Pohádka o checkpointu, CSPUG meetup, 2011 [PDF] [schedule] [slideshare]
Replikace v PostgreSQL, CSPUG Meetup 2011 [PDF]
Monitoring výkonu PostgreSQL, Prague PostgreSQL Developer Day 2011 [schedule]