actually, I didn't get near that kind of benefit ... with wal disabled,
and sort_mem/checkpoint_segments at default, I got:
import start: 22:31:38
end: 23:21:42 (~50min)
buffers: 64
sort_mem: 1024
wal disabled: yes
with checkpoint_segments and sort_mem raised, I shaved about 8min:
import start: 15:56:07
end: 16:38:56 (~42min)
buffers: 640
sort_mem: 102400
checkpoint_segments: 64
wal disabled: yes
fsync disabled: yes
As a side note, a default install with 64 shared memory buffers came in
around 56min ... then again, if looking at percentages, that is about a
25% improvement ... it just doesn't look to be that big looking at the
straight #s :)
On Tue, 23 Sep 2003, Vivek Khera wrote:
> >>>>> "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.
>