That really depends on your use cases. I love Postgres and have been using it for a long time. However if you need good support for, for example, self-updating

That really depends on your use cases. I love Postgres and have been using it for a long time. However if you need good support for, for example, self-updating efficient materialized views, then Postgres won't really do (yet).