Latest / More than a refresh: Conversations with the most interesting people you've never met
MTAR T3D Sessions: Faster Schema Changes, Slower Queries
Faster schema changes sound like an obvious improvement. But as this conversation shows, making one database operation faster can introduce performance problems that are much harder to spot.
In this Postgres Pet Peeves episode, Brian shares a real production case where adding a column with a default value led to unexpectedly slow queries. JD and Brian explore why PostgreSQL behaves this way, how the optimization introduced in PostgreSQL 11 changes what is actually written to disk, and why that can leave the query planner working with incomplete information until the table is eventually…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.