Can anyone recommend for/against the time-travel functions in postgresql's contrib/spi module? Is there an example available anywhere?
Tnx
+3
A:
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.
WolfmanDragon
2008-10-06 21:15:27
Sad. This link doesn't seem to work anymore.
Lailson Bandeira
2010-08-28 03:51:58
I found the file in the Github repo: http://github.com/postgres/postgres/blob/master/contrib/spi/timetravel.example
Lailson Bandeira
2010-08-28 03:55:58
+2
A:
See This discussion for an alternative approach to historical reporting.
ConcernedOfTunbridgeWells
2008-10-07 14:01:52