Re: Academic help for Postgres

On 05/11/2016 07:54 AM, Bruce Momjian wrote:
> On Wed, May 11, 2016 at 05:41:21PM +0300, Heikki Linnakangas wrote:
>> 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.
> 
> Oh, OK. I will add it.
> 

Together with that, automated substitution of materialized views for
query clauses.

Also: optimizing for new hardware, like persistent memory.

-- 
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)