News for hackers. Stuff that matters.

A comment on Ask HN: What could a modern database do that PostgreSQL and MySQL can't. Parent comment

Re:Ask HN: What could a modern database do that PostgreSQL a... by CharlesW on Sunday September 05, 2021 @05:04PM (#28427773)
> Creating the right indexes is the same as creating the right tables and columns in your data model: It depends on the business purpose and usage of the data.

Right, so the way this works is that the database collects instrumentation data and, over time, automatically applies strategies (indexing improvements being one of them) to improve its performance.

https://arxiv.org/abs/2007.14244

[ Parent | on HN ]
Re:Ask HN: What could a modern database do that PostgreSQL a... by Upitor on Monday September 06, 2021 @01:10AM (#28430517)
As another user wrote, some db systems already can provide suggestions for missing indexes based on stats. But automatically creating them? Should all new indexes just add up (that would fill the db pretty fast) or replace prevoius ones (what about users depending on these indexes?)
[ Parent | on HN ]