Re: postgres: 100% CPU utilization

Список
Период
Сортировка
От Mark Kirkwood
Тема Re: postgres: 100% CPU utilization
Дата
Msg-id 4631515D.2020708@paradise.net.nz
обсуждение исходный текст
Ответ на Re: postgres: 100% CPU utilization  ("Sergey Tsukinovsky")
Список pgsql-performance
Дерево обсуждения
postgres: 100% CPU utilization  ("Sergey Tsukinovsky", )
 Re: postgres: 100% CPU utilization  (Tom Lane, )
 Re: postgres: 100% CPU utilization  (Andreas Tille, )
 Re: postgres: 100% CPU utilization  (Mario Weilguni, )
  Re: postgres: 100% CPU utilization  (Ron, )
   Re: postgres: 100% CPU utilization  ("Sergey Tsukinovsky", )
    Re: postgres: 100% CPU utilization  (Scott Marlowe, )
    Re: postgres: 100% CPU utilization  (Mark Kirkwood, )
 Re: postgres: 100% CPU utilization  (Scott Marlowe, )
  Re: postgres: 100% CPU utilization  (Vivek Khera, )
   Re: postgres: 100% CPU utilization  (Scott Marlowe, )
    Re: postgres: 100% CPU utilization  (Greg Smith, )
  Re: postgres: 100% CPU utilization  (Mark Kirkwood, )
Sergey Tsukinovsky wrote:
>
> Just for the record - the hardware that was used for the test has the
> following parameters:
> AMD Opteron 2GHZ
> 2GB RAM
> LSI Logic SCSI
>

And you ran FreeBSD 4.4 on it right? This may be a source of high cpu
utilization in itself if the box is SMP or dual core, as multi-cpu
support was pretty primitive in that release (4.12 would be better if
you are required to stick to the 4.x branch, if not the 6.2 is recommended)!

Cheers

Mark



В списке pgsql-performance по дате отправления:

Предыдущее
От: Arjen van der Meijden
Дата:
Сообщение: Re: index structure for 114-dimension vector
Следующее
От: Florian Weimer
Дата:
Сообщение: Re: Filesystem fragmentation (Re: Fragmentation of WAL files)