Re: [GENERAL] Materialized view vs. view

On 01/10/2017 10:27 AM, Job wrote:
> Hi guys,
>
> iam 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?

If are running tests as you state above, you should know or am I missing
something?

>
> The view has about 500K lines.
>
> Thank you!
> /F


--
Adrian Klaver
adrian.klaver@aklaver.com