Pavlo Blog
Databases in 2023: A Year in Review
Posted on January 04, 2024Andy recounts the rise of vector databases to SQL:2023 to MariaDB troubles and the FAA outage in 2023. [READ]
Yes, PostgreSQL Has Problems. But We’re Sticking With It!
Posted on June 07, 2023Andy explores ways to optimize PostgreSQL for each of the problems caused by the implementation of multi-version concurrency control in PostgreSQL. [READ]
The Part of PostgreSQL We Hate the Most
Posted on April 26, 2023As much as Andy loves PostgreSQL, there is one part that is terrible and causes many headaches for people. Learn what it is and why it sucks. [READ]
Databases in 2022: A Year in Review
Posted on December 31, 2022Andy is back with his analysis of the database world in 2022, including VC funding, blockchains, and Larry Ellison. [READ]
Ten Database Crack Commandments
Posted on March 09, 2022In memory of Biggie Smalls, Andy Pavlo presents his 10 Database Commandments - street rules for database management. [READ]
Databases in 2021: A Year in Review
Posted on December 28, 2021Andy's take on 2021 database industry happenings - PostgreSQL, Performance Wars, Passings, and Larry Ellison. [READ]
You Are Overpaying Jeff Bezos For Your Databases (And The Things He Does With That Extra Money)
Posted on September 30, 2021Andy discusses why Jeff Bezos's Amazon Web Services makes you overpay for your database management systems. [READ]
On Naming a Database Management System
Posted on March 19, 2020Andy deliberates over naming schemes for database management systems. [READ]
An Updated Guide on Where to Apply for a PhD in Databases in the US (2018)
Posted on November 09, 2018Andy provides an updated list of US database researchers as a guide for students applying to Ph.D. programs in 2018. [READ]
What is a Self-Driving Database Management System?
Posted on April 09, 2018Andy discusses what it means to have a self-driving database management system and whether it is even possible to build one. [READ]
Building a New Database Management System in Academia
Posted on March 20, 2017Andy muses over whether it is possible to build a DBMS in academia and on using Postgres as a starting point. [READ]
Where to Apply for a PhD in Database Systems in the US (2016)
Posted on October 03, 2016Andy provides a list of his favorite database researchers in the US as a guide for students applying to graduate school. [READ]
Chasing the Dragon of OLTP Databases
Posted on August 03, 2016Andy comes clean and talks about overcoming his database performance addiction problem. [READ]
My Favorite Database Shirts
Posted on July 26, 2016Andy reviews his favorite NoSQL and NewSQL database shirts. [READ]
The Carnegie Mellon Database Application Catalog
Posted on July 05, 2016Andy announces a new on-line repository of ready-to-run database applications. [READ]
CMU's New Graduate Database System Internals Course
Posted on May 20, 2016Andy reflects on his laborious effort to teach a new course on database system internals. [READ]
Should You Email a Professor During the Ph.D. Admissions Season?
Posted on April 22, 2016Andy discusses whether a prospective Ph.D. applicant should email a faculty member. [READ]
How to Write a Bad Statement for a Computer Science Ph.D. Admissions Application
Posted on October 01, 2015Andy discuss examples of bad statements sent to CMU's Ph.D. admissions committee in hope that others don't make the same mistake. [READ]
The Next 50 Years of Databases
Posted on September 24, 2015Andy attempts to revive his blog by predicting what databases will look like in the year 2065. [READ]
Open Problems in Transaction Processing (Part 2 of 3): Many-Core CPU Architectures
Posted on September 08, 2014Andy prognosticates on the problems of using future many-core CPUs for OLTP database systems. [READ]
Open Problems in Transaction Processing (Part 1 of 3): Non-Volatile Memory
Posted on June 17, 2014Andy pontificates on open problems of non-volatile memory in OLTP systems research. [READ]
Fall 2013 Database Research Projects
Posted on December 20, 2013Andy regales everyone with the research projects from his first semester. [READ]
Whereupon Andy Gets a Blog
Posted on August 26, 2013Andy starts writing a blog and reflects on the recent job search. People will sing songs about this day for years to come. [READ]