Alan Hodgson <ahodgson@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general