Postgress is taking lot of CPU on our embedded hardware.

From: Jayashankar K B <Jayashankar(dot)KB(at)lnties(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Postgress is taking lot of CPU on our embedded hardware.
Date: 2012-01-27 13:34:15
Message-ID: 1365276B7BDA4C40A519F0B4088230B3096F3B17@POCITMSEXMB03.LntUniverse.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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%.
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.

Thanks and Regards
Jayashankar

Larsen & Toubro Limited

www.larsentoubro.com

This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Cédric Villemain 2012-01-27 14:38:53 Re: PostgreSQL Parallel Processing !
Previous Message Tomas Vondra 2012-01-27 12:43:49 Re: PostgreSQL Parallel Processing !