Re: speed up restore from dump - Mailing list pgsql-general

From Sam Mason
Subject Re: speed up restore from dump
Date
Msg-id 20081030200156.GB2459@frubble.xen.chris-lamb.co.uk
Whole thread Raw
In response to Re: speed up restore from dump  (Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>)
List pgsql-general
On Thu, Oct 30, 2008 at 07:28:57PM +0000, Joao Ferreira gmail wrote:
> On Thu, 2008-10-30 at 11:39 -0700, Alan Hodgson wrote:
> > You're probably just
> > disk-bound, though. What does vmstat say during the restore?
>
> During restore:
> # vmstat
> procs --------memory------- ---swap-- -----io---- -system-- ----cpu----
> r  b   swpd   free   buff  cache   si  so   bi   bo  in  cs us sy id wa
> 3  1 230204   4972   1352 110128   2    1   17   63  24  56 12  2 85  0
>
>
> After restore has finished
> # vmstat
> procs --------memory-------- ---swap-- ---io---- -system-- ----cpu----
> r  b   swpd   free   buff  cache   si  so   bi   bo   in   cs us sy id wa
> 1  0 246864  59972   2276 186420   2   1    18   63   28   56 12  2 85  0

From the output you've given it doesn't look as though you left vmstat
running while the processing is running, the first set of numbers it
prints out are rarely representational values for the IO usage.  Try
running "vmstat 5" to get output every 5 seconds, you should be able
to see things happening a bit more easily that way.  Another tool I'd
recommend is iostat, I tend to invoke it as "iostat -mx 5 /dev/sd?" to
get it to print out values for each individual disk.


  Sam

pgsql-general by date:

Previous
From: Kev
Date:
Subject: array_cat null reasoning
Next
From: Alan Hodgson
Date:
Subject: Re: speed up restore from dump