Re: Academic help for Postgres

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