Alvaro Herrera wrote:
Florian G. Pflug wrote:
However, I just realized that doing this is much harder than I initially
thought, because catalog access always happens with SnapshotNow, and
e.g. "drop table" deletes datafiles at commit time, and not during vacuum.
Not to mention the likenesses of CLUSTER and TRUNCATE, which would need
to be taught how to keep the old datafiles for an additional week/hour.
What I don't understand is why people isn't working in improving
contrib/spi/timetravel.
Because it serves different usecase I think - flashback is an
administrative tool, not something you design your application around.
Flashback is more similar to PITR recovery than to contrib/spi/timetravel.
greetings, Florian Pflug
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
