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

Re: speed up restore from dump

From: Joao Ferreira <jmcferreira(at)critical-links(dot)com>
To: Alan Hodgson <ahodgson(at)simkin(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: speed up restore from dump
Date: 2008-10-30 20:19:37
Message-ID: 1225397977.4340.51.camel@debj4n.critical.pt (view raw or flat)
Thread:
Lists: pgsql-general
On Thu, 2008-10-30 at 13:08 -0700, Alan Hodgson wrote:
> On Thursday 30 October 2008, Joao Ferreira gmail 
> > 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
> > #
> 
> Does that machine really have only 256MB of RAM? And it's over 200MB into 
> swap? 

well..... see for yourself... (360 RAM , 524 SWAP) that's what it is...
it supposed to be somewhat an embedded product...

# 
# cat /proc/meminfo 
MemTotal:       360392 kB
MemFree:         59548 kB
Buffers:          7392 kB
Cached:          62640 kB
SwapCached:      44724 kB
Active:         247892 kB
Inactive:        29936 kB
HighTotal:           0 kB
HighFree:            0 kB
LowTotal:       360392 kB
LowFree:         59548 kB
SwapTotal:      524280 kB
SwapFree:       292532 kB
Dirty:             744 kB
Writeback:           0 kB
AnonPages:      190344 kB
Mapped:          42772 kB
Slab:            13176 kB
SReclaimable:     5116 kB
SUnreclaim:       8060 kB
PageTables:       2728 kB
NFS_Unstable:        0 kB
Bounce:              0 kB
CommitLimit:    704476 kB
Committed_AS:  1035156 kB
VmallocTotal:   524280 kB
VmallocUsed:      4020 kB
VmallocChunk:   520164 kB
HugePages_Total:     0
HugePages_Free:      0
HugePages_Rsvd:      0
HugePages_Surp:      0
Hugepagesize:     4096 kB
# 

# cat /proc/cpuinfo 
processor	: 0
vendor_id	: CentaurHauls
cpu family	: 6
model		: 9
model name	: VIA Nehemiah
stepping	: 8
cpu MHz		: 1002.309
cache size	: 64 KB
fdiv_bug	: no
hlt_bug		: no
f00f_bug	: no
coma_bug	: no
fpu		: yes
fpu_exception	: yes
cpuid level	: 1
wp		: yes
flags		: fpu vme de pse tsc msr cx8 sep mtrr pge cmov pat mmx fxsr sse
up rng rng_en ace ace_en
bogomips	: 2009.04
clflush size	: 32



> 
> 
> -- 
> Alan
> 


In response to

Responses

pgsql-general by date

Next:From: Kyle CordesDate: 2008-10-30 20:42:59
Subject: Re: Decreasing WAL size effects
Previous:From: Alvaro HerreraDate: 2008-10-30 20:17:15
Subject: Re: speed up restore from dump

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