Noah Misch <noah@leadboat.com> wrote:
> On Thu, Apr 04, 2013 at 12:28:01PM +0200, Nicolas Barbier wrote:
>> +1. Having unlogged matviews without having incremental updates
>> yet, isn't super useful anyway.
>
> I would have surmised the opposite
Hmm. I was thinking about the fact that a full refresh can be
unlogged anyway, but that's only true if you're not using WAL for
replication. If you need a matview on the master but not on the
replica(s), then there is still benefit to declaring it to be
unlogged in the absence of incremental maintenance.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
