In Pursuit of PostgreSQL Performance (blog post)

Over the past three weeks I’ve had to chase down an issue where a server had worse performance running some complex queries when compared to running those same queries on a laptop. These differences were only significant for the most complex queries in the system - simpler queries showed no differences.

I’ve written up the details about my search for answers at: In Pursuit of PostgreSQL Performance - DEV Community

4 Likes

I just came up to this Postgres Explain Visualizer tool and remembered this article of yours.

As always, great content Ken.