| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
| Cc: | Kevin Grittner <kgrittn(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, 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 20:33:19 |
| Message-ID: | CAKFQuwaY_h8bTJ3A7t3+mTduJno66f=12k3_SMh-gq2CCL+YDQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jan 10, 2017 at 1:01 PM, Melvin Davidson <melvin6925(at)gmail(dot)com>
wrote:
>
> Can we all agree that the "Materialized View" should be faster
>
>
>
If you add in the condition that the same answer has to be returned whether
you query the view or the mat-view then no, I wouldn't agree; and the
original question is, IMO, unanswerable (or at least, if answered, requires
making assumptions that tend to go unstated).
is just an opinion and too late to change at this point?
>
>
Your opinion, or the name? :)
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2017-01-10 20:34:44 | Re: Materialized view vs. view |
| Previous Message | Rob Sargent | 2017-01-10 20:09:10 | Re: Materialized view vs. view |