Re: Academic help for Postgres

On May 12, 2016, at 6:16 AM, Rajeev rastogi wrote:

> On 11 May 2016 19:50, 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?
>
> How about?
> 1. Considering NUMA aware architecture.
> 2. Optimizer tuning as per new hardware trends.
> 3. More effective version of Join algorithms (e.g. Compare to traditional "build and then probe" mechanism of Hash Join, now there is pipelining Hash join where probe and build both happens together).

Interesting article about optimal joins: http://arxiv.org/pdf/1203.1952v1.pdf

>
> Thanks and Regards,
> Kumar Rajeev Rastogi
>
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers