Re: Materialized views in Oracle

[Ben Chobot <bench@xxxxxxxxxxxxxxx>]

On Sep 21, 2011, at 1:17 PM, Mike Christensen wrote:

So I used to think materialized views in Postgres would be an awesome feature.  That is until I had to endure the hell hole which is Oracle's implementation..  what a complete joke..  did MS SQL's indexed views do any better?  Hopefully if PG 10 implements this, they'll make it actually useful to people.

Not sure if this was a question or just blowing off frustration, but you can do materialized views in PG just fine. It's just that you have to do the work of updating them yourself. You can make a good case that's a good thing, because it lets you optimize the process around your needs..... but it does add for dba complexity.

(Hey, just like replication! :) )