Re: 8.3 / 8.2.6 restore comparison
От | Joshua D. Drake |
---|---|
Тема | Re: 8.3 / 8.2.6 restore comparison |
Дата | |
Msg-id | 47C06A0D.6070305@commandprompt.com обсуждение исходный текст |
Ответ на | Re: 8.3 / 8.2.6 restore comparison (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: 8.3 / 8.2.6 restore comparison
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-hackers |
Tom Lane wrote: > Stefan Kaltenbrunner <stefan@kaltenbrunner.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 >
В списке pgsql-hackers по дате отправления: