Re: 8.3 / 8.2.6 restore comparison

Tom Lane wrote:
> Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> writes:
>> Tom Lane wrote:
>>> The vmstat output you showed before said user CPU time was only around
>>> 12%, which seems to destroy Luke's thesis that data conversion time
>>> is the problem.
>
>> Joshua said this is an 8 core box - so 12% would about equal to one core
>> being maxed out completely CPU wise
>
> Oh, good point. That should be fairly easy to confirm with "top" I
> would think.

mpstat -P ALL 5

01:43:33 PM CPU %user %nice %sys %iowait %irq %soft %steal
%idle intr/s
01:43:38 PM all 12.70 0.00 0.15 0.05 0.00 0.00 0.00
87.10 1322.60
01:43:38 PM 0 99.60 0.00 0.40 0.00 0.00 0.00 0.00
0.00 1000.40
01:43:38 PM 1 0.20 0.00 0.00 0.40 0.00 0.00 0.00
99.40 322.00
01:43:38 PM 2 0.00 0.00 0.20 0.00 0.00 0.00 0.00
99.80 0.00
01:43:38 PM 3 2.00 0.00 0.20 0.00 0.00 0.00 0.00
97.60 0.00
01:43:38 PM 4 0.00 0.00 0.20 0.00 0.00 0.00 0.00
100.00 0.00
01:43:38 PM 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00
100.00 0.00
01:43:38 PM 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00
100.00 0.00
01:43:38 PM 7 0.00 0.00 0.20 0.00 0.00 0.00 0.00
100.00 0.00

01:43:38 PM CPU %user %nice %sys %iowait %irq %soft %steal
%idle intr/s
01:43:43 PM all 13.10 0.00 0.68 0.00 0.00 0.00 0.00
86.22 1328.20
01:43:43 PM 0 95.60 0.00 4.40 0.00 0.00 0.00 0.00
0.00 1000.40
01:43:43 PM 1 0.00 0.00 0.00 0.00 0.00 0.20 0.00
100.00 327.60
01:43:43 PM 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00
100.00 0.00
01:43:43 PM 3 9.00 0.00 1.20 0.00 0.00 0.00 0.00
89.80 0.00
01:43:43 PM 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00
100.00 0.00
01:43:43 PM 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00
100.00 0.00
01:43:43 PM 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00
100.00 0.00
01:43:43 PM 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00
100.00 0.00

01:43:43 PM CPU %user %nice %sys %iowait %irq %soft %steal
%idle intr/s
01:43:48 PM all 13.48 0.00 1.68 0.00 0.00 0.00 0.00
84.85 1345.29
01:43:48 PM 0 87.58 0.00 11.02 0.00 0.00 0.00 0.00
1.40 1002.40
01:43:48 PM 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00
100.00 343.09
01:43:48 PM 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00
100.20 0.00
01:43:48 PM 3 20.44 0.00 2.20 0.00 0.00 0.00 0.00
77.56 0.00
01:43:48 PM 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00
100.20 0.00
01:43:48 PM 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00
100.20 0.00
01:43:48 PM 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00
100.20 0.00
01:43:48 PM 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00
100.20 0.00

iostat -k 5:

avg-cpu: %user %nice %system %iowait %steal %idle
13.48 0.00 2.23 0.07 0.00 84.23

Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
sda 36.87 0.00 1443.69 0 7204
sdb 0.60 0.00 21.64 0 108
sdc 0.00 0.00 0.00 0 0
sdd 0.00 0.00 0.00 0 0
hda 0.00 0.00 0.00 0 0

avg-cpu: %user %nice %system %iowait %steal %idle
13.28 0.00 2.15 1.33 0.00 83.25

Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
sda 168.66 0.00 9947.31 0 49836
sdb 0.00 0.00 0.00 0 0
sdc 0.00 0.00 0.00 0 0
sdd 0.00 0.00 0.00 0 0
hda 0.00 0.00 0.00 0 0

avg-cpu: %user %nice %system %iowait %steal %idle
13.57 0.00 2.32 0.05 0.00 84.06

Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
sda 27.05 0.00 1425.25 0 7112
sdb 0.00 0.00 0.00 0 0
sdc 0.00 0.00 0.00 0 0
sdd 0.00 0.00 0.00 0 0
hda 0.00 0.00 0.00 0 0

vmstat -adps -S M 5
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu------
r b swpd free inact active si so bi bo in cs us sy
id wa st
1 0 0 12793 14385 4301 0 0 12 101 4 12 0 0
99 0 0
1 0 0 12694 14421 4364 0 0 0 19943 1740 435 13 2
85 0 0
1 0 0 12606 14444 4429 0 0 0 28070 1839 449 12 2
84 2 0
1 0 0 12508 14469 4503 0 0 0 9188 1501 424 13 1
85 0 0
1 0 0 12402 14498 4579 0 0 0 20746 1734 446 13 2
85 0 0

Joshua D. Drake

>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>