On Thursday, July 2, 2020, Mitar <mmi...@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.
