Re: CTE inlining

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: CTE inlining
Date: 2017-05-02 16:01:14
Message-ID: 1493740874227-5959313.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Relevant posts where users get confused by our behaviour:
> ....

And Markus Winand's blog: http://modern-sql.com/feature/with/performance

Databases generally obey this principle, although PostgreSQL represents
a big exception

and

Besides PostgreSQL, all tested databases optimize with clauses in the
same way
that they optimize views or derived tables"

--
View this message in context: http://www.postgresql-archive.org/CTE-inlining-tp5958992p5959313.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Rahila Syed 2017-05-02 16:03:03 Re: Adding support for Default partition in partitioning
Previous Message Robert Haas 2017-05-02 16:00:06 Re: logical replication syntax (was DROP SUBSCRIPTION, query cancellations and slot handling)