On Sun, Apr 30, 2017 at 5:54 PM, Tomas Vondra <tomas.von...@2ndquadrant.com> wrote: > But I keep running into people who face serious performance issues exactly > because not realizing this, and using CTEs as named subqueries. And when I > tell them "optimization fence" they react "Whaaaaaaat?" > > If I had to make up some numbers, I'd say the "Whaaaaat?" group is about 10x > the group of people who intentionally rely on CTEs being optimization > fences.
+1. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers