Tag: Memoization

I've recently discovered a pleasant new addition to PostgreSQL 14, the new enable_memoize flag that improves the performance of some nested loop joins where statistics hint at this being appropriate. I mean, who can resist this temptation: https://twitter.com/RPorsager/status/1455660236375826436 Improving query speed by 1000x hints at something very suboptimal having been going on before, and a … Continue reading PostgreSQL 14’s enable_memoize For Improved Performance of Nested Loop Joins →