CPU bound

Поиск
Список
Период
Сортировка
От Royce Ausburn
Тема CPU bound
Дата
Msg-id F13DEE85-D114-4761-AD4D-924F1A741ACC@inomial.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: SELECT INTO large FKyed table is slow
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: CPU bound