Re: [HACKERS] CTE inlining - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] CTE inlining
Date
Msg-id CA+TgmoYEQpxrpLvPeJhjH85z2qnw2qiTCtuN8TeUt2iBFAghvA@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] CTE inlining  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
On Sun, Apr 30, 2017 at 5:54 PM, Tomas Vondra
<tomas.vondra@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



pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: [HACKERS] CTE inlining
Next
From: Craig Ringer
Date:
Subject: Re: [HACKERS] CTE inlining