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.