Search Postgresql Archives

Re: speed up restore from dump

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
> 


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux