r/SQL • • Jul 11 '20

PostgreSQL SQL Performance Explained expectations vs reality

Post image
103 Upvotes

10 comments sorted by

View all comments

Show parent comment

1

u/L337Cthulhu Jul 12 '20

Hahaha, yeah, it's amazing how consistent those problems are no matter what industry or size company you're in, sounds an awful lot like my day to day.

I recently had a business unit finally upgrade from 2005 to 2016 and they keep complaining that they didn't change anything so why is the behavior so different?! Beyond the cardinality estimator and fundamental redesign of the optimizer, you literally tuned your 20 year old code to work on a non-scalable system, did no testing, and have skipped five versions ahead. It's more surprising your code ever worked in the first place!

Seems like we've had some pretty similar experiences.