More than a refresh: Conversations with the most interesting people you've never met podkast

MTAR T3D Sessions: Understanding PostgreSQL Query Plans and Testing Real Workloads.

0:00
11:15
Do tyłu o 15 sekund
Do przodu o 15 sekund

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 environment. On query plans, he wants clearer EXPLAIN documentation and more insight into the planner’s decisions.

Hunter also wants a quick way to generate an entity relationship diagram (ERD) when working with unfamiliar schemas, particularly when the best documentation is a busy senior developer. Some of these needs have existing tools or workarounds; the challenge is making them practical for everyday database work.

Więcej odcinków z kanału "More than a refresh: Conversations with the most interesting people you've never met"