3 ms·
There's an extension to add partial support of this to Postgres: https://github.com/arkhipov/temporal_tables https://github.com/arkhipov/temporal_tables I have
by clarkdave 10y ago
There's an extension to add partial support of this to Postgres: https://github.com/arkhipov/temporal_tables https://github.com/arkhipov/temporal_tables
I have used it in production for years and it works great, but does indeed use a lot of disk space if you enable it for all tables and have many updates.
It's not a full implementation (it lacks the new syntax like `AS OF SYSTEM TIME`) but you can work around that with `UNION` queries and the containment (`@>`) operator.