Compiler-style optimization for Postgres

All of the posts claiming that the technology already existed are missing that I don't want to spend our time in the real world I'm sure there's a sweet spot.