Re: speed up restore from dump - Mailing list pgsql-general

From Joao Ferreira
Subject Re: speed up restore from dump
Date
Msg-id 1225397977.4340.51.camel@debj4n.critical.pt
Whole thread Raw
In response to Re: speed up restore from dump  (Alan Hodgson <ahodgson@simkin.ca>)
List 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
>


pgsql-general by date:

Previous
From: Chris Butler
Date:
Subject: Connections getting stuck sending data to client
Next
From: "Noah Freire"
Date:
Subject: Re: autovacuum