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
>> 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 (firstname.lastname@example.org)
> To make changes to your subscription:
Sent via pgsql-hackers mailing list (email@example.com)
To make changes to your subscription: