On 11/05/16 17:32, Bruce Momjian wrote:
> On Wed, May 11, 2016 at 05:31:10PM +0300, Konstantin Knizhnik wrote:
>> On 11.05.2016 17:20, Bruce Momjian wrote:
>>> I am giving a keynote at an IEEE database conference in Helsinki next
>>> week (http://icde2016.fi/). (Yes, I am not attending PGCon Ottawa
>>> because I accepted the Helsinki conference invitation before the PGCon
>>> Ottawa date was changed from June to May).
>>>
>>> As part of the keynote, I would like to mention areas where academia can
>>> help us. The topics I can think of are:
>>>
>>> Query optimization
>>> Optimizer statistics
>>> Indexing structures
>>> Reducing function call overhead
>>> CPU locality
>>> Sorting
>>> Parallelism
>>> Sharding
>>>
>>> Any others?
>>>
>> Incremental materialized views?
>
> I don't know. Is that something academics would research?
Absolutely! There are plenty of papers on how to keep materialized views
up-to-date.
- Heikki