"Ruairi" <rcarroll@xxxxxxxxxxxxxx> writes: > I'm currently restoring a fairly large DB from a pg_dump and it's taking > about 12 hours to finish. The main part of this time is spent creating > indexes. Is there anyway I can speed up the restore process, or do i just > have to wait? There's not much you can do to improve the performance of a restore already in progress. Next time you might want to think about kicking up maintenance_work_mem before you start it; that's about the only thing you can really do to speed up index builds. (Actually, if there are lots of indexes yet to be built, increasing the setting in postgresql.conf and SIGHUP'ing the postmaster could be worth doing, as that should affect the builds yet to be done.) regards, tom lane
