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