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

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

From: Andy Colson <andy(at)squeakycode(dot)net>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: Jayashankar K B <Jayashankar(dot)KB(at)lnties(dot)com>, "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-27 17:14:50
Message-ID: 4F22DB8A.4080104@squeakycode.net (view raw or flat)
Thread:
Lists: pgsql-performance
On 1/27/2012 10:47 AM, Heikki Linnakangas wrote:
> On 27.01.2012 15:34, Jayashankar K B 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.
>
> Fascinating!
>
>> 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%.
>> This is suffocating the various other processes running on the system.
>> Couple of them are very critical ones.
>> The testing involves inserting bulk number of records (approx. 10000
>> records having between 10 and 20 columns).
>> Please let us know how we can reduce CPU usage for the postgres.
>
> The first step would be to figure out where all the time is spent. Are
> there unnecessary indexes you could remove? Are you using INSERT
> statements or COPY? Sending the data in binary format instead of text
> might shave some cycles.
>

Do you have triggers on the table?



In response to

Responses

pgsql-performance by date

Next:From: Jon NelsonDate: 2012-01-27 17:43:10
Subject: regarding CLUSTER and HUGE work_mem / maintenance_work_mem
Previous:From: Heikki LinnakangasDate: 2012-01-27 16:47:36
Subject: Re: Postgress is taking lot of CPU on our embedded hardware.

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