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: (view raw, whole thread or download thread mbox)
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
> 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)!



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-2017 The PostgreSQL Global Development Group