On Thu, 2008-10-30 at 11:39 -0700, Alan Hodgson wrote: > On Thursday 30 October 2008, Joao Ferreira gmail > <[EMAIL PROTECTED]> 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 > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
