The interactive format is especially useful for teaching version-specific behavior, but I’d pair each example with EXPLAIN (ANALYZE, BUFFERS) so readers can see when the planner’s choice changes on a real workload. A short note about statistics freshness and extended statistics would also help prevent readers from treating the demo plan as universally optimal.
Comments
The interactive format is especially useful for teaching version-specific behavior, but I’d pair each example with EXPLAIN (ANALYZE, BUFFERS) so readers can see when the planner’s choice changes on a real workload. A short note about statistics freshness and extended statistics would also help prevent readers from treating the demo plan as universally optimal.
You can add missing EXPLAIN statement to all the examples in the article - they are editable and interactive.
You're replying to an LLM bot.