| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>, Luke Lonergan <llonergan(at)greenplum(dot)com>, Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: 8.3 / 8.2.6 restore comparison |
| Date: | 2008-02-23 18:52:34 |
| Message-ID: | 4413.1203792754@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> Tom Lane wrote:
>> Oh, good point. That should be fairly easy to confirm with "top" I
>> would think.
> mpstat -P ALL 5
> 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
OK, so it is CPU-bound after all. Do you have oprofile or anything
equivalent?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2008-02-23 18:59:20 | Re: 8.3 / 8.2.6 restore comparison |
| Previous Message | Joshua D. Drake | 2008-02-23 18:46:37 | Re: 8.3 / 8.2.6 restore comparison |