Re: Postgress is taking lot of CPU on our embedded hardware. - Mailing list pgsql-performance

From Jose Ildefonso Camargo Tolosa
Subject Re: Postgress is taking lot of CPU on our embedded hardware.
Date
Msg-id CAETJ_S-7qRHUS_Yf7jvS_OyppxpVE0BX9uDr5OPu2y-kXZAcpQ@mail.gmail.com
Whole thread Raw
In response to Re: Postgress is taking lot of CPU on our embedded hardware.  (Jayashankar K B <Jayashankar.KB@lnties.com>)
List pgsql-performance
Greetings,

On Sat, Jan 28, 2012 at 12:51 PM, Jayashankar K B
<Jayashankar.KB@lnties.com> wrote:
> Hi,
>
> I downloaded the source code and cross compiled it into a relocatable package and copied it to the device.
> LTIB was the cross-compile tool chain that was used. Controller is  coldfire MCF54418 CPU.
> Here is the configure options I used.

Ok, no floating point, and just ~250MHz... small.  Anyway, lets not
talk about hardware options, because you already have it.

About kernel, I'm not sure if on this arch you have the option, but
did you enable "PREEMPT" kernel config option? (on menuconfig:
"Preemptible Kernel (Low-Latency Desktop)")....  Or, is that a RT
kernel?

With such a small CPU, almost any DB engine you put there will be
CPU-hungry, but if your CPU usage is under 95%, you know you still
have some CPU to spare, on the other hand, if you are 100% CPU, you
have to evaluate required response time, and set priorities
accordingly.. However, I have found that, even with processes with
nice level 19 using 100% CPU, other nice level 0 processes will
slow-down unless I set PREEMPT option to on kernel compile options
(other issue are IO wait times, at least on my application that uses
CF can get quite high).

Sincerely,

Ildefonso Camargo

pgsql-performance by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Postgress is taking lot of CPU on our embedded hardware.
Next
From: Ron Arts
Date:
Subject: Having I/O problems in simple virtualized environment