"Jim C. Nasby" <jnasby@xxxxxxxxxxxxx> writes: > Oh, so in other words, SELECT * INTO temp FROM table is inherently > non-deterministic at the physical level, so the only way to be able to > allow PITR to work is to duplicate all the physical changes. Darn. Well, lemme put it this way: I'm not prepared to require that PG be deterministic at the physical level. One obvious source of non-determinancy is the FSM, which is likely to hand out different free space to different transactions depending on what else is going on at the same time. There are others, such as deliberately random tie-breaking during btree index insertion. regards, tom lane
