# Andy Pavlo - Carnegie Mellon University

Andy Pavlo - Carnegie Mellon University,

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Databases in 2025: A Year in Review

DevFeed: [Databases in 2025: A Year in Review](<https://devfeed.tech/articles/databases-in-2025-a-year-in-review-33719.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2026/01/2025-databases-retrospective.html>)

Author: Andy Pavlo

Published: 2026-01-04T05:00:00Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [review](<https://devfeed.tech/tags/review.md>)

### AI overview

An opinionated review of major database trends and events in 2025, highlighting PostgreSQL's continued prominence and changes in its version 18 release, including asynchronous I/O, skip scans, and query-optimizer improvements.

### Source excerpt

The world tried to kill Andy off but he had to stay alive to to talk about what happened with databases in 2025.

## Databases in 2024: A Year in Review

DevFeed: [Databases in 2024: A Year in Review](<https://devfeed.tech/articles/databases-in-2024-a-year-in-review-33718.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2025/01/2024-databases-retrospective.html>)

Author: Andy Pavlo

Published: 2025-01-01T05:00:00Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Database](<https://devfeed.tech/topics/database.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [elasticsearch](<https://devfeed.tech/topics/elasticsearch.md>), [Redis](<https://devfeed.tech/topics/redis.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [MongoDB](<https://devfeed.tech/topics/mongodb.md>), [amazon](<https://devfeed.tech/topics/amazon.md>)

Tags: [amazon](<https://devfeed.tech/tags/amazon.md>), [blog](<https://devfeed.tech/tags/blog.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [elasticsearch](<https://devfeed.tech/tags/elasticsearch.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [redis](<https://devfeed.tech/tags/redis.md>)

### AI overview

A retrospective on the 2024 database ecosystem, focusing on database-company business models, cloud competition, and restrictive source-code license changes involving Redis and Elasticsearch, with additional discussion of MongoDB and hosted database services.

### Source excerpt

Andy rises from the ashes of his dead startup and discusses what happened in 2024 in the database game.

## Databases in 2023: A Year in Review

DevFeed: [Databases in 2023: A Year in Review](<https://devfeed.tech/articles/databases-in-2023-a-year-in-review-33717.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2024/01/2023-databases-retrospective.html>)

Author: Andy Pavlo

Published: 2024-01-04T05:00:00Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Embeddings](<https://devfeed.tech/topics/embeddings.md>), [data](<https://devfeed.tech/topics/data.md>), [Large Language Model](<https://devfeed.tech/topics/llm.md>), [Transformer](<https://devfeed.tech/topics/transformer.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [chatgpt](<https://devfeed.tech/tags/chatgpt.md>), [databases](<https://devfeed.tech/tags/databases.md>), [embeddings](<https://devfeed.tech/tags/embeddings.md>), [review](<https://devfeed.tech/tags/review.md>), [searching](<https://devfeed.tech/tags/searching.md>), [transformers](<https://devfeed.tech/tags/transformers.md>), [trends](<https://devfeed.tech/tags/trends.md>), [vector](<https://devfeed.tech/tags/vector.md>), [year-in-review](<https://devfeed.tech/tags/year-in-review.md>)

### AI overview

An annual review of major database developments and trends in 2023, focusing on the rise of vector databases and their use of embeddings and similarity search in applications influenced by large language models.

### Source excerpt

Andy recounts the rise of vector databases to SQL:2023 to MariaDB troubles and the FAA outage in 2023.

## Optimizing PostgreSQL's MVCC: Version Copying, Table Bloat, and Vacuum Management

DevFeed: [Optimizing PostgreSQL's MVCC: Version Copying, Table Bloat, and Vacuum Management](<https://devfeed.tech/articles/yes-postgresql-has-problems-but-we-re-sticking-with-it-33716.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2023/06/yes-postgresql-has-problems-but-were-sticking-with-it.html>)

Author: Andy Pavlo

Published: 2023-06-07T04:00:00Z

Content type: article

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Concurrency](<https://devfeed.tech/topics/concurrency.md>), [Optimization](<https://devfeed.tech/topics/optimization.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [implementation](<https://devfeed.tech/topics/implementation.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [implementation](<https://devfeed.tech/tags/implementation.md>), [optimization](<https://devfeed.tech/tags/optimization.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [storage](<https://devfeed.tech/tags/storage.md>), [vacuum](<https://devfeed.tech/tags/vacuum.md>)

### AI overview

The article examines PostgreSQL's multi-version concurrency control and discusses optimization challenges involving version copying, table bloat, index maintenance, and vacuum management. It explains how version copying increases data duplication and storage demands, while dead tuples can increase I/O and hurt performance.

### Source excerpt

Andy explores ways to optimize PostgreSQL for each of the problems caused by the implementation of multi-version concurrency control in PostgreSQL.

## PostgreSQL's MVCC Implementation and Its Operational Challenges

DevFeed: [PostgreSQL's MVCC Implementation and Its Operational Challenges](<https://devfeed.tech/articles/the-part-of-postgresql-we-hate-the-most-33715.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2023/04/the-part-of-postgresql-we-hate-the-most.html>)

Author: Andy Pavlo

Published: 2023-04-26T04:00:00Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Concurrency](<https://devfeed.tech/topics/concurrency.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [blog](<https://devfeed.tech/tags/blog.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

### AI overview

The article explains multi-version concurrency control (MVCC) and argues that PostgreSQL's implementation creates operational problems compared with other relational database systems. It describes how MVCC keeps physical row versions so concurrent queries can read and write without unnecessary blocking.

### Source excerpt

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.

## Databases in 2022: A Year in Review

DevFeed: [Databases in 2022: A Year in Review](<https://devfeed.tech/articles/databases-in-2022-a-year-in-review-33714.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2022/12/2022-databases-retrospective.html>)

Author: Andy Pavlo

Published: 2022-12-31T05:00:00Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [data](<https://devfeed.tech/topics/data.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [MariaDB](<https://devfeed.tech/topics/mariadb.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>), [Streaming](<https://devfeed.tech/topics/streaming.md>), [Time Series](<https://devfeed.tech/topics/time-series.md>)

Tags: [analysis](<https://devfeed.tech/tags/analysis.md>), [announcements](<https://devfeed.tech/tags/announcements.md>), [blog](<https://devfeed.tech/tags/blog.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [funding](<https://devfeed.tech/tags/funding.md>), [mariadb](<https://devfeed.tech/tags/mariadb.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [query](<https://devfeed.tech/tags/query.md>), [review](<https://devfeed.tech/tags/review.md>), [streaming](<https://devfeed.tech/tags/streaming.md>), [time-series](<https://devfeed.tech/tags/time-series.md>), [year-in-review](<https://devfeed.tech/tags/year-in-review.md>)

### AI overview

A retrospective on the database world in 2022, covering quieter benchmark competition, database startup funding, and notable developments involving companies and technologies such as PostgreSQL, DuckDB, Druid, Trino, and MariaDB. It finds that large funding rounds slowed substantially in the second half of the year.

### Source excerpt

Andy is back with his analysis of the database world in 2022, including VC funding, blockchains, and Larry Ellison.

## Ten Database Crack Commandments

DevFeed: [Ten Database Crack Commandments](<https://devfeed.tech/articles/ten-database-crack-commandments-33713.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2022/03/database-ten-commandments.html>)

Author: Andy Pavlo

Published: 2022-03-09T05:00:00Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Database](<https://devfeed.tech/topics/database.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>)

Tags: [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [blog](<https://devfeed.tech/tags/blog.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>)

### AI overview

Andy Pavlo presents ten practical rules for database management, inspired by The Notorious B.I.G.'s "Ten Crack Commandments." The supplied passages discuss negotiating database pricing and keeping future tool choices private, with examples involving Oracle licensing and Amazon RDS Reserved Instances.

### Source excerpt

In memory of Biggie Smalls, Andy Pavlo presents his 10 Database Commandments - street rules for database management.

## Databases in 2021: A Year in Review

DevFeed: [Databases in 2021: A Year in Review](<https://devfeed.tech/articles/databases-in-2021-a-year-in-review-33712.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2021/12/2021-databases-retrospective.html>)

Author: Andy Pavlo

Published: 2021-12-28T07:18:19Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [Benchmark](<https://devfeed.tech/topics/benchmark.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [blog](<https://devfeed.tech/tags/blog.md>), [databases](<https://devfeed.tech/tags/databases.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [elasticsearch](<https://devfeed.tech/tags/elasticsearch.md>), [google](<https://devfeed.tech/tags/google.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [year-in-review](<https://devfeed.tech/tags/year-in-review.md>)

### AI overview

A retrospective on 2021 database-industry developments, focusing on PostgreSQL's growing adoption, compatibility across database systems, rankings, community discussion, funding, acquisitions, and industry setbacks.

### Source excerpt

Andy's take on 2021 database industry happenings - PostgreSQL, Performance Wars, Passings, and Larry Ellison.

## How AWS Customers Can Reduce Unnecessary Database Costs

DevFeed: [How AWS Customers Can Reduce Unnecessary Database Costs](<https://devfeed.tech/articles/you-are-overpaying-jeff-bezos-for-your-databases-and-the-things-he-does-with-that-extra-money-33711.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2021/09/you-are-overpaying-jeff-bezos-for-your-databases.html>)

Author: Andy Pavlo

Published: 2021-09-30T04:00:00Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Amazon Web Services (AWS)](<https://devfeed.tech/topics/amazon-web-services-aws.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [optimize](<https://devfeed.tech/topics/optimize.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Benchmark](<https://devfeed.tech/topics/benchmark.md>)

Tags: [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-web-services](<https://devfeed.tech/tags/amazon-web-services.md>), [aws](<https://devfeed.tech/tags/aws.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [blog](<https://devfeed.tech/tags/blog.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [optimize](<https://devfeed.tech/tags/optimize.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

### AI overview

The article discusses how AWS customers may incur unnecessary database costs, particularly through unoptimized RDS instances and blindly increasing instance sizes. It explains the limits of vertical scaling and mentions a PostgreSQL RDS experiment using the TPC-C benchmark.

### Source excerpt

Andy discusses why Jeff Bezos's Amazon Web Services makes you overpay for your database management systems.

## On Naming a Database Management System

DevFeed: [On Naming a Database Management System](<https://devfeed.tech/articles/on-naming-a-database-management-system-33710.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2020/03/on-naming-a-database-management-system.html>)

Author: Andy Pavlo

Published: 2020-03-19T11:18:01Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [systems](<https://devfeed.tech/topics/systems.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [systems](<https://devfeed.tech/tags/systems.md>)

### AI overview

Andy discusses why naming database management systems is difficult, drawing on his experience with H-Store and Peloton and describing naming considerations for a new Postgres-compatible DBMS at Carnegie Mellon.

### Source excerpt

Andy deliberates over naming schemes for database management systems.

## An Updated Guide on Where to Apply for a PhD in Databases in the US (2018)

DevFeed: [An Updated Guide on Where to Apply for a PhD in Databases in the US (2018)](<https://devfeed.tech/articles/an-updated-guide-on-where-to-apply-for-a-phd-in-databases-in-the-us-2018-33709.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2018/11/an-updated-guide-on-where-to-apply-for-a-phd-in-databases-in-the-us-2018.html>)

Author: Andy Pavlo

Published: 2018-11-09T09:25:01Z

Content type: tutorial

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [guide](<https://devfeed.tech/tags/guide.md>), [updated](<https://devfeed.tech/tags/updated.md>), [us](<https://devfeed.tech/tags/us.md>)

### AI overview

An updated 2018 guide to U.S. database groups and researchers for students applying to Ph.D. programs. It emphasizes advisor fit over rankings and notes that faculty availability may vary.

### Source excerpt

Andy provides an updated list of US database researchers as a guide for students applying to Ph.D. programs in 2018.

## What is a Self-Driving Database Management System?

DevFeed: [What is a Self-Driving Database Management System?](<https://devfeed.tech/articles/what-is-a-self-driving-database-management-system-33708.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2018/04/what-is-a-self-driving-database-management-system.html>)

Author: Andy Pavlo

Published: 2018-04-09T16:46:18Z

Content type: article

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Machine learning](<https://devfeed.tech/topics/machine-learning.md>), [systems](<https://devfeed.tech/topics/systems.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [database](<https://devfeed.tech/tags/database.md>), [machine-learning](<https://devfeed.tech/tags/machine-learning.md>), [optimize](<https://devfeed.tech/tags/optimize.md>), [research](<https://devfeed.tech/tags/research.md>)

### AI overview

The article defines a true self-driving database management system as one that automatically chooses optimization actions, decides when to deploy them, and learns from their effects without human intervention. It distinguishes this concept from merely running machine learning inside a DBMS and places it within the history of autonomous database research.

### Source excerpt

Andy discusses what it means to have a self-driving database management system and whether it is even possible to build one.

## Building a New Database Management System in Academia

DevFeed: [Building a New Database Management System in Academia](<https://devfeed.tech/articles/building-a-new-database-management-system-in-academia-33707.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2017/03/building-a-new-database-management-system-in-academia.html>)

Author: Andy Pavlo

Published: 2017-03-21T01:54:17Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [database](<https://devfeed.tech/tags/database.md>), [management](<https://devfeed.tech/tags/management.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgres](<https://devfeed.tech/tags/postgres.md>)

### AI overview

Andy Pavlo discusses whether academia can build a new database management system, describing his group's planned open-source DBMS project and the challenges involved. He reports that using PostgreSQL as a starting point was too slow for in-memory OLTP and outlines the substantial infrastructure required to build a DBMS from scratch.

### Source excerpt

Andy muses over whether it is possible to build a DBMS in academia and on using Postgres as a starting point.

## Where to Apply for a PhD in Database Systems in the US (2016)

DevFeed: [Where to Apply for a PhD in Database Systems in the US (2016)](<https://devfeed.tech/articles/where-to-apply-for-a-phd-in-database-systems-in-the-us-2016-33706.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2016/10/where-to-apply-for-a-phd-in-database-systems-in-the-us-2016.html>)

Author: Andy Pavlo

Published: 2016-10-03T19:45:22Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [systems](<https://devfeed.tech/topics/systems.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [database](<https://devfeed.tech/tags/database.md>), [guide](<https://devfeed.tech/tags/guide.md>), [list](<https://devfeed.tech/tags/list.md>), [research](<https://devfeed.tech/tags/research.md>), [us](<https://devfeed.tech/tags/us.md>)

### AI overview

Andy provides a personal, non-exhaustive list of database research groups and researchers in the United States that students may consider when applying to PhD programs in 2016. He also explains why students should discuss their goals early with potential research advisers.

### Source excerpt

Andy provides a list of his favorite database researchers in the US as a guide for students applying to graduate school.

## Reflecting on an Addiction to OLTP Database Performance Optimization

DevFeed: [Reflecting on an Addiction to OLTP Database Performance Optimization](<https://devfeed.tech/articles/chasing-the-dragon-of-oltp-databases-33705.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2016/08/chasing-the-dragon-of-oltp-databases.html>)

Author: Andy Pavlo

Published: 2016-08-03T16:07:04Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [databases](<https://devfeed.tech/tags/databases.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [performance](<https://devfeed.tech/tags/performance.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

### AI overview

The author reflects on moving beyond an intense focus on OLTP throughput and database performance. He describes progressively higher H-Store transaction-throughput results and the diminishing personal satisfaction they provided.

### Source excerpt

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

## My Favorite Database Shirts

DevFeed: [My Favorite Database Shirts](<https://devfeed.tech/articles/my-favorite-database-shirts-33704.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2016/07/my-favorite-database-shirts.html>)

Author: Andy Pavlo

Published: 2016-07-26T13:31:11Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Database](<https://devfeed.tech/topics/database.md>), [NoSQL](<https://devfeed.tech/topics/nosql.md>), [MongoDB](<https://devfeed.tech/topics/mongodb.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [compare](<https://devfeed.tech/tags/compare.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [design](<https://devfeed.tech/tags/design.md>), [logo-design](<https://devfeed.tech/tags/logo-design.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [reviews](<https://devfeed.tech/tags/reviews.md>)

### AI overview

Andy reviews five favorite database company shirts, focusing on material quality, fit, and design. The article uses these shirt characteristics as a playful basis for comparing database companies, including MongoDB and other NoSQL and NewSQL startups.

### Source excerpt

Andy reviews his favorite NoSQL and NewSQL database shirts.

## The Carnegie Mellon Database Application Catalog

DevFeed: [The Carnegie Mellon Database Application Catalog](<https://devfeed.tech/articles/the-carnegie-mellon-database-application-catalog-33703.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2016/07/carnegie-mellon-database-application-catalog.html>)

Author: Andy Pavlo

Published: 2016-07-05T13:49:30Z

Content type: release

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [benchmarking](<https://devfeed.tech/topics/benchmarking.md>), [datasets](<https://devfeed.tech/topics/datasets.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarking](<https://devfeed.tech/tags/benchmarking.md>), [blog](<https://devfeed.tech/tags/blog.md>), [database](<https://devfeed.tech/tags/database.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [release](<https://devfeed.tech/tags/release.md>), [repository](<https://devfeed.tech/tags/repository.md>), [research](<https://devfeed.tech/tags/research.md>)

### AI overview

Andy announces the Carnegie Mellon Database Application Catalog, an online repository of open-source database applications that can be automatically deployed and executed locally for benchmarking and experimentation. The article explains that the catalog addresses the difficulty of accessing representative workloads and datasets in database systems research.

### Source excerpt

Andy announces a new on-line repository of ready-to-run database applications.

## CMU's New Graduate Database System Internals Course

DevFeed: [CMU's New Graduate Database System Internals Course](<https://devfeed.tech/articles/cmu-s-new-graduate-database-system-internals-course-33702.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2016/05/new-database-system-internals-course.html>)

Author: Andy Pavlo

Published: 2016-05-20T19:15:22Z

Content type: article

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [Code](<https://devfeed.tech/topics/code.md>), [Development](<https://devfeed.tech/topics/development.md>), [Job](<https://devfeed.tech/topics/job.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [code](<https://devfeed.tech/tags/code.md>), [database](<https://devfeed.tech/tags/database.md>), [development](<https://devfeed.tech/tags/development.md>), [internals](<https://devfeed.tech/tags/internals.md>), [job](<https://devfeed.tech/tags/job.md>), [memcached](<https://devfeed.tech/tags/memcached.md>), [test](<https://devfeed.tech/tags/test.md>), [videos](<https://devfeed.tech/tags/videos.md>)

### AI overview

Andy Pavlo reflects on creating and teaching CMU's 15-721 Database Systems course, including its focus on database management system internals, practical coding experience, and recorded lectures. He discusses course preparation, student projects, and lessons for improving the course.

### Source excerpt

Andy reflects on his laborious effort to teach a new course on database system internals.

## Should You Email a Professor During the Ph.D. Admissions Season?

DevFeed: [Should You Email a Professor During the Ph.D. Admissions Season?](<https://devfeed.tech/articles/should-you-email-a-professor-during-the-ph-d-admissions-season-33701.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2016/04/should-you-email-a-professor-during-admissions-season.html>)

Author: Andy Pavlo

Published: 2016-04-22T13:23:04Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Computer science](<https://devfeed.tech/topics/computer-science.md>), [email](<https://devfeed.tech/topics/email.md>)

Tags: [academics](<https://devfeed.tech/tags/academics.md>), [blog](<https://devfeed.tech/tags/blog.md>), [computer-science](<https://devfeed.tech/tags/computer-science.md>), [email](<https://devfeed.tech/tags/email.md>), [research](<https://devfeed.tech/tags/research.md>)

### AI overview

An academic discusses whether prospective Ph.D. applicants should email professors during admissions season. The article argues that such emails increase faculty workload but generally do not improve an applicant's admission chances, although targeted and thoughtful messages may receive a response.

### Source excerpt

Andy discusses whether a prospective Ph.D. applicant should email a faculty member.

## How to Write a Bad Statement for a Computer Science Ph.D. Admissions Application

DevFeed: [How to Write a Bad Statement for a Computer Science Ph.D. Admissions Application](<https://devfeed.tech/articles/how-to-write-a-bad-statement-for-a-computer-science-ph-d-admissions-application-33700.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2015/10/how-to-write-a-bad-statement-for-a-computer-science-phd-admissions-application.html>)

Author: Andy Pavlo

Published: 2015-10-01T13:46:23Z

Content type: article

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Computer science](<https://devfeed.tech/topics/computer-science.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [computer-science](<https://devfeed.tech/tags/computer-science.md>), [examples](<https://devfeed.tech/tags/examples.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [statement](<https://devfeed.tech/tags/statement.md>)

### AI overview

The article discusses examples of poor statements of purpose submitted to CMU's computer science Ph.D. admissions committee. It explains why childhood "boy genius" openings are considered irrelevant and unpersuasive.

### Source excerpt

Andy discuss examples of bad statements sent to CMU's Ph.D. admissions committee in hope that others don't make the same mistake.

## The Next 50 Years of Databases

DevFeed: [The Next 50 Years of Databases](<https://devfeed.tech/articles/the-next-50-years-of-databases-33699.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2015/09/the-next-50-years-of-databases.html>)

Author: Andy Pavlo

Published: 2015-09-24T23:37:31Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Computer science](<https://devfeed.tech/topics/computer-science.md>), [systems](<https://devfeed.tech/topics/systems.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [databases](<https://devfeed.tech/tags/databases.md>), [research](<https://devfeed.tech/tags/research.md>), [space](<https://devfeed.tech/tags/space.md>)

### AI overview

Andy examines the history and present state of database systems before offering a personal vision of what they may look like in 2065. The article discusses early systems such as IBM IMS, System R, and INGRES, along with changing workloads and architectures.

### Source excerpt

Andy attempts to revive his blog by predicting what databases will look like in the year 2065.

## Open Problems in Transaction Processing (Part 2 of 3): Many-Core CPU Architectures

DevFeed: [Open Problems in Transaction Processing (Part 2 of 3): Many-Core CPU Architectures](<https://devfeed.tech/articles/open-problems-in-transaction-processing-part-2-of-3-many-core-cpu-architectures-33698.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2014/09/open-problems-in-transaction-processing-part-2.html>)

Author: Andy Pavlo

Published: 2014-09-08T12:39:59Z

Content type: article

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [systems](<https://devfeed.tech/topics/systems.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [cpu](<https://devfeed.tech/topics/cpu.md>), [Hardware](<https://devfeed.tech/topics/hardware.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [memory](<https://devfeed.tech/tags/memory.md>), [performance](<https://devfeed.tech/tags/performance.md>), [power](<https://devfeed.tech/tags/power.md>), [processors](<https://devfeed.tech/tags/processors.md>), [research](<https://devfeed.tech/tags/research.md>), [scale](<https://devfeed.tech/tags/scale.md>), [scaling](<https://devfeed.tech/tags/scaling.md>)

### AI overview

The second article in a three-part series examines open research problems in transaction-processing database systems as CPU architectures move from multi-core to many-core designs. It discusses limits in existing DBMS architectures and evaluations, and explains why future systems with hundreds or thousands of low-power cores may require different software approaches.

### Source excerpt

Andy prognosticates on the problems of using future many-core CPUs for OLTP database systems.

## Open Problems in Transaction Processing (Part 1 of 3): Non-Volatile Memory

DevFeed: [Open Problems in Transaction Processing (Part 1 of 3): Non-Volatile Memory](<https://devfeed.tech/articles/open-problems-in-transaction-processing-part-1-of-3-non-volatile-memory-33697.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2014/06/open-problems-in-transaction-processing-part-1.html>)

Author: Andy Pavlo

Published: 2014-06-17T19:55:05Z

Content type: opinion

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [systems](<https://devfeed.tech/topics/systems.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [database](<https://devfeed.tech/tags/database.md>), [memory](<https://devfeed.tech/tags/memory.md>), [opinion](<https://devfeed.tech/tags/opinion.md>), [research](<https://devfeed.tech/tags/research.md>), [systems](<https://devfeed.tech/tags/systems.md>)

### AI overview

The article discusses unresolved research problems in online transaction processing database systems, focusing first on non-volatile memory. It reviews the evolution of main-memory database systems and argues that core main-memory DBMS research is largely mature, while commercial engineering challenges remain.

### Source excerpt

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

## Fall 2013 Database Research Projects

DevFeed: [Fall 2013 Database Research Projects](<https://devfeed.tech/articles/fall-2013-database-research-projects-33696.md>)

Original publisher: [Read original article](<https://www.cs.cmu.edu/~pavlo/blog/2013/12/fall-2013-research.html>)

Author: Andy Pavlo

Published: 2013-12-21T03:46:32Z

Content type: article

Language: en

Sources: [Andy Pavlo - Carnegie Mellon University](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [systems](<https://devfeed.tech/topics/systems.md>), [benchmarking](<https://devfeed.tech/topics/benchmarking.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [database](<https://devfeed.tech/tags/database.md>), [performance](<https://devfeed.tech/tags/performance.md>), [replication](<https://devfeed.tech/tags/replication.md>), [research](<https://devfeed.tech/tags/research.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

### AI overview

A professor reviews research projects from the fall 2013 semester, including a study comparing active-active and active-passive replication schemes in distributed main-memory database management systems. The project uses VoltDB and the TPC-C workload to compare performance, but the supplied text ends before reporting the results.

### Source excerpt

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

[Next page](<https://devfeed.tech/sources/andy-pavlo-carnegie-mellon-university.md?cursor=WyIyMDEzLTEyLTIxVDAzOjQ2OjMyKzAwOjAwIiwgIjEwNTc4NzA2LWE0ZWUtNGZmYS1iYzRlLWZjODQ1ZDIxNWMwYiJd>)