Re: Materialized views in Oracle

On Wed, Sep 21, 2011 at 2:54 PM, Ben Chobot <bench(at)silentmedia(dot)com> wrote:
> 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.

Well if you set it up with triggers etc you can have materialized
views that autoupdate, but that may or may not be the best way to do
things for your particular workload.