On Thursday, July 2, 2020, Mitar <
mmitar@gmail.com> wrote:
make queries asking for
results at the particular historical version of table state?
Even for a single table how would you go about specifying this in a user-friendly way? Then consider joins.
Is this something I would have to run a custom version of PostgreSQL
or is this possible through an extension of sort?
If by “this” you mean leveraging MVCC you don’t; it isn’t suitable for persistent temporal data.
The fundamental missing piece is that there is no concept of timestamp in MVCC. Plus, wrap-around and freezing aren’t just nice-to-have features.
David J.