On Thursday, July 2, 2020, Mitar <mmitar(at)gmail(dot)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.