On Tue, 23 Sep 2003, Tom Lane wrote:
> Vivek Khera <khera@kcilink.com> writes:
> > Well, for me the create index part of the restore is what takes about
> > 3x the time for the data load. Total about 4 hours. The dump takes 1
> > hour.
>
> What sort_mem do you use for the restore? Have you tried increasing it?
I've tried restoring a >5gig database with sort_mem up to 100Meg in size,
and didn't find that it sped up the index creation enough to make a
difference ... shaved off a couple of minutes over the whole reload, so
seconds off of each index ... and that was with the WAL logs also disabled
:(