Version 12, Inlining of - With CTEs - has been a big win for us, we have seen some dramatic improvements in performance. Also Parallel query to take advantage o

Version 12, Inlining of - With CTEs - has been a big win for us, we have seen some dramatic improvements in performance. Also Parallel query to take advantage of multi core processors has improved performance in general since 9.6. I also like Lateral joins especially with Set Returning functions, they are literally like magic.