PostgreSQL is a great database — but every technology involves trade-offs and limitations.   In this talk, Robert Haas lists many of issues that PostgreSQL faces, from the on-disk format to logical replication to connection pooling. What issues exist, what can be done to improve things, and what are the core developers doing to move in that direction? If you’re a user of PostgreSQL, or just curious to learn about the architecture of relational databases, this talk should be of great interest to you.