HiveBrain v1.2.0
Get Started
← Back to all entries
patternModerate

What other databases have a feature similar to Oracle's Flashback Query?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
oracledatabaseswhatqueryflashbackothersimilarhavefeature

Problem

I am interested to know what other databases have features similar to Oracle's Flashback Query. It would seem that any database that supports MVCC could have the feature, but which do? SO has this question for SQL Server, but it seems more appropriate here.

Solution

PostgreSQL does not currently have it. But you are right, with MVCC it should theoretically be possible. In fact, the old university Postgres had an equivalent feature called time travel, but it was later removed because it caused too much overhead and the practical use was limited. While it would probably be possible to resurrect it, since then there have been many optimizations to the MVCC setup that would make it much harder.

Context

StackExchange Database Administrators Q#359, answer score: 18

Revisions (0)

No revisions yet.