Re: speed up restore from dump

On Thu, 2008-10-30 at 11:39 -0700, Alan Hodgson wrote:
> On Thursday 30 October 2008, Joao Ferreira gmail
> <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> wrote:
> > What other cfg paramenters shoud I touch ?
>
> work_mem set to most of your free memory might help.

I've raised work_mem to 128MB.

still get the same 20 minutes !

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

joao

>
> --
> Alan
>