Skip site navigation (1) Skip section navigation (2)

Re: speed up restore from dump

From: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: speed up restore from dump
Date: 2008-10-30 19:28:57
Message-ID: 1225394937.4340.47.camel@debj4n.critical.pt (view raw or flat)
Thread:
Lists: pgsql-general
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
> 


Responses

pgsql-general by date

Next:From: Sam MasonDate: 2008-10-30 20:01:56
Subject: Re: speed up restore from dump
Previous:From: Glyn AstillDate: 2008-10-30 19:19:29
Subject: Re: bytea field, a c function and pgcrypto driving me mad

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group