On Wed, Sep 21, 2011 at 2:54 PM, Ben Chobot <bench@xxxxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
