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) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
