Re: I don't want to back up index files - Mailing list pgsql-general

From Tom Lane
Subject Re: I don't want to back up index files
Date
Msg-id 18402.1236900487@sss.pgh.pa.us
Whole thread Raw
In response to Re: I don't want to back up index files  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-general
Alan Hodgson <ahodgson@simkin.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: I don't want to back up index files
Next
From: Glen Parker
Date:
Subject: Re: I don't want to back up index files