Re: Postgresql Materialized views

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.