CPU bound - Mailing list pgsql-performance

From Royce Ausburn
Subject CPU bound
Date
Msg-id F13DEE85-D114-4761-AD4D-924F1A741ACC@inomial.com
Whole thread Raw
Responses Re: CPU bound  (Craig Ringer <craig@postnewspapers.com.au>)
Re: CPU bound  (Josh Berkus <josh@agliodbs.com>)
Re: CPU bound  (James Cloos <cloos@jhcloos.com>)
List pgsql-performance
Hi all,

I notice that when restoring a DB on a laptop with an SDD, typically postgres is maxing out a CPU - even during a COPY.
I wonder, what is postgres usually doing with the CPU?  I would have thought the disk would usually be the bottleneck
inthe DB, but occasionally it's not.  We're embarking on a new DB server project and it'd be helpful to understand
wherethe CPU is likely to be the bottleneck. 

Cheers,

--Royce


pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: SELECT INTO large FKyed table is slow
Next
From: Craig Ringer
Date:
Subject: Re: CPU bound