Skip site navigation (1) Skip section navigation (2)

Re: postgres: 100% CPU utilization

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Sergey Tsukinovsky <Sergey(dot)Tsukinovsky(at)cryptologic(dot)com>
Cc: Ron <rjpeace(at)earthlink(dot)net>, Mario Weilguni <mweilguni(at)sime(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: postgres: 100% CPU utilization
Date: 2007-04-27 01:26:53
Message-ID: 4631515D.2020708@paradise.net.nz (view raw or flat)
Thread:
Lists: 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



In response to

pgsql-performance by date

Next:From: Carlos MorenoDate: 2007-04-27 01:58:53
Subject: Feature Request --- was: PostgreSQL Performance Tuning
Previous:From: Alexander StauboDate: 2007-04-26 23:14:34
Subject: Re: Simple query, 10 million records...MySQL ten times faster

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group