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