Re: Postgress is taking lot of CPU on our embedded hardware.

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Jayashankar K B <Jayashankar(dot)KB(at)lnties(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Postgress is taking lot of CPU on our embedded hardware.
Date: 2012-01-28 03:07:31
Message-ID: CAOR=d=2xOXzr4_Zy3VF4vw+vguvpmu7J2sdfWyUtUAvUvuBVog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Jan 27, 2012 at 6:34 AM, Jayashankar K B
<Jayashankar(dot)KB(at)lnties(dot)com> wrote:
> Hi,
>
> We are having an embedded system with a freescale m68k architecture based
> micro-controller, 256MB RAM running a customized version of Slackware 12
> linux.
>
> It’s a relatively modest Hardware.
>
> We have installed postgres 9.1 as our database engine. While testing, we
> found that the Postgres operations take more than 70% of CPU and the average
> also stays above 40%.

Not to dissuade you from using pgsql, but have you tried other dbs
like the much simpler SQL Lite?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Pavel Stehule 2012-01-28 06:37:36 Re: pl/pgsql functions outperforming sql ones?
Previous Message Scott Marlowe 2012-01-28 03:04:00 Re: regarding CLUSTER and HUGE work_mem / maintenance_work_mem