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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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