lephyrius

"generally you want -O2"

I see this a lot shouldn't O3 produce better optimizations? Is that people have large codebases? OR is it that O3 does some CPU/memory tradeoffs? OR something else?

I see that it's an issue. But the places you use locals in a template is small. Majority of the templates would still benefit. Like the main layout and so on.

No, partial updates of materialized views it seems like.