Talks and Blogs
Talks
Everything you want to know about Postgres autovacuum
Postgres Conference 2024.
Bohan discusses the internals of Postgres autovacuum, strategies for effective monitoring and tuning, and provides real-world examples. [Slides]
The Part of PostgreSQL I Hate the Most
Postgres Conference Silicon Valley 2023.
Bohan explores the implementation of Multi-Version Concurrency Control (MVCC) in Postgres, the issues it causes, and optimization strategies. [Slides]
Lessons Learned from Automatically Optimizing Databases Using Machine Learning in the Real World
HTAP Summit 2023.
Bohan discusses lessons learned from applying machine learning to automate optimization of real-world databases at OtterTune. [Slides]
OtterTune: Automatic database optimization using machine learning
Postgres Conference Asia 2021, 2020.
Bohan introduces OtterTune, an automatic database knob tuning service using machine learning.
Blogs
I wrote technical blogs on database internals and optimizations, some hitting HackerNews front page.
The part of PostgreSQL we hate the most
Posted on Apr, 2023. (w/Andy Pavlo)
Bohan and Andy make the claim that Postgres’s approach to multi-version concurrency control 'sucks' and we go into detail as to why.
[HackerNews][Postgres Weekly][Reddit]
Yes, PostgreSQL has problems, but we’re sticking with it!
Posted on June, 2023. (w/Andy Pavlo)
Bohan and Andy explore strategies to address challenges caused by the implementation of multi-version concurrency control in Postgres.
Query best practices: When should you use the IN instead of the OR operator?
Posted on August, 2023.
Bohan advises using IN clauses instead of OR clauses with PostgreSQL, and discusses the reasons.
[HackerNews]
How Amazon RDS replication works and why the FAA’s database problem won’t happen in AWS
Posted on Jan, 2023.
All flights were grounded on Jan 11, 2023 due to an FAA system outage. Bohan discusses how replication works in AWS to prevent such incidents.
Fixing slow PostgreSQL queries: How to make a smart optimizer more stupid
Posted on August, 2022. (w/Haonan Wang)
Haonan and Bohan discuss their approach to improving the performance of a customer's LIMIT ORDER BY query by up to 10,000 times.
[HackerNews]
Run ANALYZE. Run ANALYZE. Run ANALYZE
Posted on May, 2022.
Bohan discusses how we reduced a customer's job time from 52 minutes to just 34 seconds by running ANALYZE.