this is the kind of research that creates new db types, or super optimized postgres im not sure yet

can be both, psql has pluggable storage engines. See any of the numerous columnar or sharding extensions for postgres for examples of prior art.