Re:MariaDB Raises $9M More, Michael Howard Named New CEO, Mo...
by vogan42 on Saturday January 23, 2016 @03:50AM
(#10957717)
I don't disagree that oracle has excellent materialized view support, but triggers and other strategies can go a long way also, I think Dan Chak did a really nice chapter on this in his book enterprise rails, that is also available online for free at http://dan.chak.org/enterprise-rails/chapter-12-materialized...
Although it has nothing to do with materialized views Oracle also has a built in scheduler, which can be used to do periodic refreshes (hourly, nightly, etc). You can achieve something similar with postgres by croning a SQL script.
To my knowledge postgres doesn't really have these things (other than in 9.5? you can do refreshes without getting an exclusive lock like in 9.4), although I could be wrong. I just wish Oracle wasn't so expensive.