Pavlo Blog

Databases in 2023: A Year in Review

Posted on January 04, 2024

Andy 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, 2023

Andy 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, 2023

As 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, 2022

Andy 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, 2022

In 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, 2021

Andy'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, 2021

Andy 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, 2020

Andy 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, 2018

Andy 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, 2018

Andy 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, 2017

Andy 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, 2016

Andy 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, 2016

Andy comes clean and talks about overcoming his database performance addiction problem. [READ]

My Favorite Database Shirts

Posted on July 26, 2016

Andy reviews his favorite NoSQL and NewSQL database shirts. [READ]

The Carnegie Mellon Database Application Catalog

Posted on July 05, 2016

Andy 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, 2016

Andy 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, 2016

Andy 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, 2015

Andy 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, 2015

Andy 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, 2014

Andy 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, 2014

Andy pontificates on open problems of non-volatile memory in OLTP systems research. [READ]

Fall 2013 Database Research Projects

Posted on December 20, 2013

Andy regales everyone with the research projects from his first semester. [READ]

Whereupon Andy Gets a Blog

Posted on August 26, 2013

Andy starts writing a blog and reflects on the recent job search. People will sing songs about this day for years to come. [READ]