Re: external sort performance

From: Jeremy Harris <jgh(at)wizmail(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: external sort performance
Date: 2011-11-20 13:56:14
Message-ID: 4EC906FE.5040902@wizmail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jon Nelson 2011-11-20 15:00:41 Re: external sort performance
Previous Message Greg Smith 2011-11-19 16:21:43 Re: Benchmarking tools, methods