This talk is part of the ML⇄DB Seminar Series. Zoom Link: https://cmu.zoom.us/j/91461275681 (Passcode 177332) Read More

In hypertext world connection proxies is a must for many decades now. And in many cases this idea works for databases too! Today almost any busy OLTP Postgres instance have to use some sort of proxy: old but gold PgBouncer, scalable Odyssey or entirely new SPQR\PgCat. In this talk I'll discuss what allows proxies to be useful, what Postgres hackers... Read More

PostgreSQL traditionally has handled IO in a fairly minimal way, relying on the operating system more than most other databases. This talk will discuss why PostgreSQL mostly got away with that so far, why current hardware trends (NVMe with very high bandwidth / low latency, cloud storage with high latency but​ good random / concurrent read behaviour) require changing course... Read More

In this talk, I'll talk at a high level about how the PostgreSQL query planner approaches join planning, and how it gathers and uses statistics. Without losing sight of the fact that these algorithms generally work, I want to highlight some of the annoying cases where they break down, and the problems that they can cause for users and developers.... Read More