Latest / More than a refresh: Conversations with the most interesting people you've never met
MTAR T3D Sessions: Understanding PostgreSQL Query Plans and Testing Real Workloads.
EXPLAIN shows the query plan, but understanding why PostgreSQL chose it can take more digging. Testing how a database will behave under a real workload brings its own challenges, especially when a benchmark doesn’t reflect the application you support.
In this Postgres Wishlist episode, Hunter O’Brien, Junior Systems Administrator and Junior DBA at Command Prompt, joins JD to talk through the tools he wishes were easier to use. His experience adapting pgbench tests leads to a conversation about reproducing application workloads and the complications of using production data in a test…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.