News for hackers. Stuff that matters.
Re:Following a Select Statement Through Postgres Internals (... by go_prodev on Monday April 11, 2016 @08:17AM (#11470996)
Rewrite transforms the sql to use a pre-aggregated materialized view if one exists
Re:Following a Select Statement Through Postgres Internals (... by anarazel on Wednesday April 13, 2016 @12:07AM (#11485673)
PostgreSQL, unfortunately, can't do that. But if it were to happen, it'd not be in the rewriter. It'd not make sense to attempt such transformations before some other optimizations (like flattening of subqueries et al), and that happens in the optimization step