Postgres Pro
Downloads
Home   >   mailing lists

Re: Drastic performance loss in assert-enabled build in HEAD - Mailing list pgsql-hackers

From Noah Misch
Subject Re: Drastic performance loss in assert-enabled build in HEAD
Date
Msg-id 20130404220039.GA27169@tornado.leadboat.com
Whole thread Raw
In response to Re: Drastic performance loss in assert-enabled build in HEAD  (Nicolas Barbier <nicolas.barbier@gmail.com>)
Responses Re: Drastic performance loss in assert-enabled build in HEAD
Re: Drastic performance loss in assert-enabled build in HEAD
List pgsql-hackers
Tree view 
On Thu, Apr 04, 2013 at 12:28:01PM +0200, Nicolas Barbier wrote:
> 2013/4/3 Tom Lane <tgl@sss.pgh.pa.us>:
> > And if you're absolutely convinced that unlogged matviews mustn't work as I
> > suggest, we can lose those from 9.3, too.
> 
> +1. Having unlogged matviews without having incremental updates yet,
> isn't super useful anyway.

I would have surmised the opposite: since an unlogged MV requires a full
refresh at unpredictable moments, logged MVs will be preferred where a refresh
is prohibitively expensive.  Why might unlogged-MV applications desire
incremental updates more acutely than logged-MV applications?

-- 
Noah Misch
EnterpriseDB                                 http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: matview scannability rehash (was Re: Drastic performance loss in assert-enabled build in HEAD)
Next
From: Tom Lane
Date:
Subject: Re: matview scannability rehash (was Re: Drastic performance loss in assert-enabled build in HEAD)