> You seem to be suggesting that using the id is less useful than the
> time, but surely it's going to be easier to say "this disaster happened
> in transaction 123 so lets do a PITR up to 122" than to say "this
Transaction IDs are assigned at transaction start but what you really
want is some indicator of when the commit occurred.
Transaction 123 may have committed while 122 was still running.