On 12/05/16 02: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?
>
optimization of performance under very heavy loads ranging from almost all reads to almost all writes/updates, &
otherusage profiles single box, and multiple boxen
large numbers of CPU's
most efficient use of SSD's
best use of insanely large amounts of RAM
optimization of handling arrays & JSON structures
Cheers,
Gavin