Re: external sort performance - Mailing list pgsql-performance

From Jeremy Harris
Subject Re: external sort performance
Date
Msg-id 4EC906FE.5040902@wizmail.org
Whole thread Raw
In response to external sort performance  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Responses Re: external sort performance
List pgsql-performance
On 2011-11-17 17:10, Jon Nelson wrote:
> external sort ended, 7708696 disk blocks used: CPU 359.84s/57504.66u
> sec elapsed 58966.76 sec
>
> Am I to understand that the CPU portion of the sorting only took 6
> minutes but the sort itself took almost 16.5 hours and used approx
> 60GB of disk space?


I realise you've had helpful answers by now, but.... that reads
as 16 hours of cpu time to me; mostly user-mode but with 6 minute
of system-mode.  98% cpu usage for the 16 hours elapsed.

--
Jeremy

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Benchmarking tools, methods
Next
From: Jon Nelson
Date:
Subject: Re: external sort performance