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

Поиск
Список
Период
Сортировка
От Jayashankar K B
Тема Re: Postgress is taking lot of CPU on our embedded hardware.
Дата
Msg-id 1365276B7BDA4C40A519F0B4088230B3096F3C0D@POCITMSEXMB03.LntUniverse.com
обсуждение исходный текст
Ответ на Re: Postgress is taking lot of CPU on our embedded hardware.  (Andy Colson <andy@squeakycode.net>)
Ответы Re: Postgress is taking lot of CPU on our embedded hardware.  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Re: Postgress is taking lot of CPU on our embedded hardware.  (Jeff Janes <jeff.janes@gmail.com>)
Re: Postgress is taking lot of CPU on our embedded hardware.  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список pgsql-performance
Hi Heikki Linnakangas: We are using series of Insert statements to insert the records into database.
Sending data in binary is not an option as the module that writes into DB has been finalized.
We do not have control over that.

Hi Andy: As of now, there are no triggers in the table.

Please let me know how we can proceed. On the net I couldn't get hold of any good example where Postgres has been used
onlimited Hardware system. 
We are starting to feel if Postgres was a good choice for us..!

Thanks and Regards
Jay

-----Original Message-----
From: Andy Colson [mailto:andy@squeakycode.net]
Sent: Friday, January 27, 2012 10:45 PM
To: Heikki Linnakangas
Cc: Jayashankar K B; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Postgress is taking lot of CPU on our embedded hardware.

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?




Larsen & Toubro Limited

www.larsentoubro.com

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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: regarding CLUSTER and HUGE work_mem / maintenance_work_mem
Следующее
От: "Carlo Stonebanks"
Дата:
Сообщение: Re: pl/pgsql functions outperforming sql ones?