Skip site navigation (1) Skip section navigation (2)

Re: 8.3 / 8.2.6 restore comparison

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 (view raw or flat)
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

In response to

Responses

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2008-02-23 18:59:20
Subject: Re: 8.3 / 8.2.6 restore comparison
Previous:From: Joshua D. DrakeDate: 2008-02-23 18:46:37
Subject: Re: 8.3 / 8.2.6 restore comparison

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group