Time Travel functions in postgresql

Question

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

Tnx

I always hear people saying how much better postgresql is than mysql, but now you tell me it has time travel?? amazing!! — davr, Oct 03 '08 at 20:22
:-) 'Time travel' is the ability to see the DB as it was in the past - i.e., what values were present in a table at some point earlier on. Have a loot at http://www.postgresql.org/docs/8.3/static/contrib-spi.html. — Yuval, Oct 03 '08 at 20:25

score 5 · Accepted Answer · answered Oct 06 '08 at 21:15

5

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.

answered Oct 06 '08 at 21:15

WolfmanDragon

7,851
14
49
61

1

I found the file in the Github repo: http://github.com/postgres/postgres/blob/master/contrib/spi/timetravel.example – Lailson Bandeira Aug 28 '10 at 03:55

score 3 · Answer 2 · edited May 23 '17 at 12:26

3

See This discussion for an alternative approach to historical reporting.

edited May 23 '17 at 12:26

Community

1
1

answered Oct 07 '08 at 14:01

ConcernedOfTunbridgeWells

64,444
15
143
197

Time Travel functions in postgresql

2 Answers2