Hi guys,
i am making some tests with a massive number of "select" queries (only for reading datas) on a view and a materialized view.
We use Postgresql 9.6.1 on a 64bit server.
Only for "select" queries, which one is faster and less expensive as resources cost?
The view or the materialized view?
The view has about 500K lines.
Thank you!
/F