Re: State of Beta 2 - Mailing list pgsql-general

From Marc G. Fournier
Subject Re: State of Beta 2
Date
Msg-id 20030923161413.I27456@ganymede.hub.org
Whole thread Raw
In response to Re: State of Beta 2  (Vivek Khera <khera@kcilink.com>)
List pgsql-general
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.
>

pgsql-general by date:

Previous
From: apb18@cornell.edu
Date:
Subject: Inheritance and query plans
Next
From: Manfred Koizar
Date:
Subject: Re: How to get the total number of rows returned by query