I am looking forward to the day it supports table access methods that enables variety of use cases out of box.

Something like rocksdb as PG backend would be fantastic. Yugabyte does this but it's not PG.