Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 681
Yuval Avatar asked Oct 03 '08 20:10

Yuval


1 Answers

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.

like image 118
WolfmanDragon Avatar answered Oct 21 '22 18:10

WolfmanDragon