Mark Mielke wrote: > Alvaro Herrera wrote: >> But you had to modify your queries. I would think that a materialized >> views implementation worth its salt would put the view to work on the >> original, unmodified queries. > > I might be slow today (everyday? :-) ) - but what do you mean by this? The > only difference between *_table and *_view is that *_table is the summary > table and *_view is the view.
My point is that you should be able to query _table and the system should automatically use the view, without you saying so (except by initially creating them). At least if you had eagerly-updated materialized views. If you had lazy ones, I think those should be used explicitely only. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
