On Sat, Jan 28, 2012 at 19:11, Jayashankar K B
wrote:
> But we are stumped by the amount of CPU Postgres is eating up.
You still haven't told us *how* slow it actually is and how fast you
need it to be? What's your database layout like (tables, columns,
indexes, foreign keys)? What do the queries
Greetings,
On Sat, Jan 28, 2012 at 12:51 PM, Jayashankar K B
wrote:
> Hi,
>
> I downloaded the source code and cross compiled it into a relocatable package
> and copied it to the device.
> LTIB was the cross-compile tool chain that was used. Controller is coldfire
> MCF54418 CPU.
> Here is the
If you can batch the inserts into groups (of say 10 to 100) it might
help performance - i.e:
Instead of
INSERT INTO table VALUES(...);
INSERT INTO table VALUES(...);
...
INSERT INTO table VALUES(...);
do
INSERT INTO table VALUES(...),(...),...,(...);
This reduces the actual number of INSERT
On Sat, Jan 28, 2012 at 2:21 PM, Jayashankar K B
wrote:
>
> ./configure
> CC=/opt/freescale/usr/local/gcc-4.4.54-eglibc-2.10.54/m68k-linux/bin/m68k-linux-gnu-gcc
> CFLAGS='-fmessage-length=0 -fpack-struct -mcpu=54418 -msoft-float'
> --host=i686-pc-linux-gnu --target=m68k-linux-gnu
> --prefix=/
On Fri, Jan 27, 2012 at 10:30 AM, Jayashankar K B
wrote:
> 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.
nd Regards
> Jayashankar
>
> -Original Message-
> From: Claudio Freire [mailto:klaussfre...@gmail.com]
> Sent: Saturday, January 28, 2012 7:54 AM
> To: Heikki Linnakangas
> Cc: Jayashankar K B; Andy Colson; pgsql-performance@postgresql.org
> Subject: Re: [PERFORM]
Thanks and Regards
Jayashankar
-Original Message-
From: Claudio Freire [mailto:klaussfre...@gmail.com]
Sent: Saturday, January 28, 2012 7:54 AM
To: Heikki Linnakangas
Cc: Jayashankar K B; Andy Colson; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Postgress is taking lot of CPU on ou
Heikki Linnakangas
Sent: Saturday, January 28, 2012 1:27 AM
To: Jayashankar K B
Cc: Andy Colson; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Postgress is taking lot of CPU on our embedded hardware.
On 27.01.2012 20:30, Jayashankar K B wrote:
> Hi Heikki Linnakangas: We are using ser
On Fri, Jan 27, 2012 at 6:34 AM, 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.
>
> We have installed postgres 9.1
On Fri, Jan 27, 2012 at 4:56 PM, Heikki Linnakangas
wrote:
> I don't think there's anything particular in postgres that would make it a
> poor choice on a small system, as far as CPU usage is concerned anyway. But
> inserting rows in a database is certainly slower than, say, writing them
> into a
On 27.01.2012 20:30, Jayashankar K B wrote:
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.
That certainly limit
lto:a...@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
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.
Fascina
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 dat
14 matches
Mail list logo
