[ehfeng]

Hi author here. I actually just learned this from you. https://www.postgresql.org/docs/9.6/sql-prepare.html will be my lunchtime reading. Thanks!

[hobs]

Yeah, parameter sniffing is also a concern and a thing you have to manage on the SQL Server side - it's led to probably the most venerable article on the topic in that community - http://www.sommarskog.se/query-plan-mysteries.html

[munk-a]

Neato! If you investigate and find stuff I'd look forward to seeing your analysis, the work you did on standard statements is quite interesting.