On Thu, 2008-10-30 at 11:39 -0700, Alan Hodgson wrote:
> On Thursday 30 October 2008, Joao Ferreira gmail
> <joao.miguel.c.ferreira@gmail.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
>