There are also other way, such as bitemporal tables. - https://aiven.io/blog/two-dimensional-time-with-bitemporal-data https://aiven.io/blog/two-dimensional-ti

There are also other way, such as bitemporal tables. - https://aiven.io/blog/two-dimensional-time-with-bitemporal-data https://aiven.io/blog/two-dimensional-time-with-bitemporal-d... - https://github.com/scalegenius/pg_bitemporal https://github.com/scalegenius/pg_bitemporal 4 timestamps and some ugly queries.