Re: Materialized view vs. view

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Job <Job(at)colliniconsulting(dot)it>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Materialized view vs. view
Date: 2017-01-10 18:36:33
Message-ID: 876b9ab4-fb82-7fa5-1426-e218799d22ae@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2017-01-10 18:39:30 Re: i got a process holding the lock
Previous Message Job 2017-01-10 18:27:41 Materialized view vs. view