Re: State of Beta 2

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.
>