Le 10/33/2017 à 21:33, David G. Johnston écrivait : > On Tue, Jan 10, 2017 at 1:01 PM, Melvin Davidson > <[1]melvin6...@gmail.com> wrote: > > Can we all agree that the "Materialized View" should be faster > > Yes. The OP told about a 500K rows view. Every select queries on that view will have to fetch those 500K rows before - in any case this is quite slow. However, 500K rows do not represent a huge physical space to materialize. But do not forget to index/refresh the materialized views, depending on the select set of queries to run.
Answer would have been different with 50K rows I guess. > > 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. > > References > > 1. mailto:melvin6...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
