| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carlos Moreno | 2007-04-27 01:58:53 | Feature Request --- was: PostgreSQL Performance Tuning |
| Previous Message | Alexander Staubo | 2007-04-26 23:14:34 | Re: Simple query, 10 million records...MySQL ten times faster |