On 11.05.2016 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?
>
I am not sure.
There is definitely a question which views can be incrementally
recalculated and which inductive extension has to be constructed to make
it possible. If you google for "incremental materialized views phd", you
will get a larger number of references to articles.
But I do not know if all question in this area are already closed or not...
--
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company