From: Andy Colson <andy@squeakycode.net>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: Jayashankar K B <Jayashankar.KB@lnties.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Postgress is taking lot of CPU on our embedded hardware.
Date: Fri, 27 Jan 2012 11:14:50 -0600
Message-ID: <4F22DB8A.4080104@squeakycode.net> (raw)
In-Reply-To: <4F22D528.6090604@enterprisedb.com>
References: <1365276B7BDA4C40A519F0B4088230B3096F3B17@POCITMSEXMB03.LntUniverse.com>
<4F22D528.6090604@enterprisedb.com>
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: andy@squeakycode.net, heikki.linnakangas@enterprisedb.com, Jayashankar.KB@lnties.com
Subject: Re: Postgress is taking lot of CPU on our embedded hardware.
In-Reply-To: <4F22DB8A.4080104@squeakycode.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox