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.

prpl 3 hours ago | parent | next [-]

Salesforce runs Salesforce on postgres with LSM:

	▲	tehlike 3 hours ago \| parent [-]
		Likely their own fork, not plain PG.

OrioleDB seems interesting, not sure it's what you're after but worth a look.

	▲	tehlike 3 hours ago \| parent [-]
		It is, but it's not usable right now without some patches to postgres. At least that was the case as of PG17, and very likely 18 too. Context: https://www.orioledb.com/docs#:~:text=OrioleDB%20currently%2...