Simon Riggs wrote:
The idea of auto rebuilding indexes following recovery has already been proposed, so is under consideration. It hasn't been proposed in relation to the use case you mention, so that is new. If we did as you suggest then it would speed up the base backup but would also add index rebuild time onto the end of any recovery.
Forgive me for being stupid, but isn't a time when all the data for a table is being streamed in, during restore, the *perfect* time to build an index? Why wait until after the restore? Cheers, Jeremy -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
