Re:Following a Select Statement Through Postgres Internals (...
by anonetal on Sunday April 10, 2016 @06:49PM
(#11468568)
Rewrite phase is also supposed to "flatten subqueries/views" (cf. "Extensible/rule based query rewrite optimization in Starburst"; SIGMOD 92) and can be fairly complex. PostgreSQL doesn't do it to the same extent as DB2, but there is certainly some complex logic involved there.
[ Parent
| on HN ]
Re:Following a Select Statement Through Postgres Internals (...
by anarazel on Sunday April 10, 2016 @07:41PM
(#11468750)
That paper's definition of rewriting isn't the same as postgres' (they even say that: "The work presented here should not be confused with the query rewrite facility of POSTGRES [SJGP90]."). Flattening subqueries and views happens during planning in postgres.
Source: I'm a PostgreSQL Developer.