3 ms·
Modern PostgreSQL views are internally implemented using rules (https://www.postgresql.org/docs/current/static/rules-views.html https://www.postgresql.org/docs/
by colanderman 8y ago
Modern PostgreSQL views are internally implemented using rules (https://www.postgresql.org/docs/current/static/rules-views.html https://www.postgresql.org/docs/current/static/rules-views.h...)
- anarazel 8y agoTrue. But it's imo sad thing that it is so (at the very least it leads to duplicated functionality and duplicates query tree copies, but it also makes it harder to implement functionality like automatic matview usage etc). I'm quite sure that nobody would implement views in today's postgres that way. If there weren't the fact that there's still resistance to removing rules, I'd argue we should reimplement them.