Comment by asdf88990
5 hours ago
Yes, not only is there always improvements to existing functionality possible due to changes in improvements in general software engineering and mathematical methods beyond it or supporting new hardware features.
Generally, software engineering like other industries is evolving and there is need for different facilities. Consider graph and vector databases featuring, as well as json columns as examples of things you that are relatively recently in common use.
> Consider graph and vector databases
sounds like a revolutionary rather than incremental change, does that get into postgres?
Yes, postgres has all sorts of features that hadn't been planned on or even conceived of (at least AFAIK) when the project started. It goes far beyond the bog standard SQL queries you'll find in introductory material.