3 ms·
... that seems thoroughly backwards to me, at least in terms of expectations. I mean, I know that views that were optimization boundaries wouldn't be useful, b
by Pxtl 13y ago
... that seems thoroughly backwards to me, at least in terms of expectations. I mean, I know that views that were optimization boundaries wouldn't be useful, but just from an intuitive perspective I'd expect that the stand-alone database objects would be optimization boundaries while the query-supporting statements would be optimized as part of the query.
- einhverfr 13y agoActually PostgreSQL allows you to write views which have optimization fences for security reasons. See security barrier views.