Are there any Datomic-like query layers on top of Postgres for approaches like this where you're recording immutable occurrences rather than updating mutable records?
On the other hand, the increase in exploration costs should be more than offset by having most data changes logged to be able to track changes.