CODEWITHSUNDEEP
postgresqltime-travel
Yuval
Yuval

Reputation: 1382

Time Travel functions in postgresql

Can anyone recommend for/against the time-travel functions in postgresql's contrib/spi module? Is there an example available anywhere?

Tnx

Upvotes: 11

Views: 5374

Answers (2)

ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells

Reputation: 66612

See This discussion for an alternative approach to historical reporting.

Upvotes: 3

WolfmanDragon
WolfmanDragon

Reputation: 7942

The argument for time-travel would be being able to look at tables that are updated often at an earlier insertion/deletion point. Say a table of stock prices for a firms investment portfolio.
The argument against would be the extra storage space it eats up.

Here is an Example of use.

Upvotes: 5

Related Questions