>>>>> "MGF" == Marc G Fournier <scrappy@postgresql.org> writes:
MGF> I've tried restoring a >5gig database with sort_mem up to 100Meg in size,
MGF> and didn't find that it sped up the index creation enough to make a
MGF> difference ... shaved off a couple of minutes over the whole reload, so
MGF> seconds off of each index ... and that was with the WAL logs also disabled
MGF> :(
Ditto for me. Can you reproduce my results by increasing
checkpoint_buffers to some large value (I use 50)? this shaved
something like 60 minutes off of my restore.