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]

• BRIN Index Improvements, pgday.uk 2023 [PDF] [schedule]

2022

• BRIN Index Improvements, pgconf.eu 2022 [PDF] [schedule]

• BRIN Index Improvements, PostgresLondon 2022 [PDF] [schedule]

• Does the data/WAL page size actually matter?, PostgresVision 2022 [PDF] [schedule] [YouTube]

• BRIN Index Improvements, P2D2 2022 [PDF] [schedule]

• CREATE STATISTICS improvements, pgconf.de 2022 [PDF] [schedule]

2021

• Kam kráčíš, PostgreSQL 2021 [PDF] [schedule]

2020

• Co je nového v PostgreSQL 12 (a 13), Prague PostgreSQL Developer Day 2020 [PDF] [schedule]

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

• Paralelní dotazy v PostgreSQL 9.6 (a 10.0), Prague PostgreSQL Developer Day 2017 [PDF] [schedule]

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

• Užitečné ale opomíjené extenze, Prague PostgreSQL Developer Day 2013 [PDF] [schedule]

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]