Alan Hodgson <ahodgson(at)simkin(dot)ca> writes:
> I have done PITR recoveries (unfortunately). The log replay time dwarfs the
> time it takes to copy the index files back over (it is, honestly, slower
> than the original transactions were).
Yeah :-( ... the problem is that recovery is serialized while the
original transactions might have run in parallel. There is work
going on to improve that, but I don't know how much better it's
likely to get.
regards, tom lane