Re: postgres: 100% CPU utilization - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: postgres: 100% CPU utilization
Date
Msg-id 4631515D.2020708@paradise.net.nz
Whole thread Raw
In response to Re: postgres: 100% CPU utilization  ("Sergey Tsukinovsky" <Sergey.Tsukinovsky@cryptologic.com>)
List pgsql-performance
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 by date:

Previous
From: "Alexander Staubo"
Date:
Subject: Re: Simple query, 10 million records...MySQL ten times faster
Next
From: joe@omc-international.com.au
Date:
Subject: Re: Simple query, 10 million records...MySQL ten times faster