Re: Academic help for Postgres

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