Check out our framework for bitemporlity: https://github.com/scalegenius/pg_bitemporal We use it in production for 5 years. I am ready to answer any performance/indexing and other questions