Re: Postgress is taking lot of CPU on our embedded hardware. - Mailing list pgsql-performance

From Claudio Freire
Subject Re: Postgress is taking lot of CPU on our embedded hardware.
Date
Msg-id CAGTBQpZSNqR+__+aEFmrtTK22O39cCDL0N6SNBDkiZ-baN0rHQ@mail.gmail.com
Whole thread Raw
In response to Re: Postgress is taking lot of CPU on our embedded hardware.  (Jayashankar K B <Jayashankar.KB@lnties.com>)
List pgsql-performance
On Sat, Jan 28, 2012 at 2:21 PM, Jayashankar K B
<Jayashankar.KB@lnties.com> 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=/home/jayashankar/databases/Postgre_8.4.9_relocatable/
>
> Any other special flags that could be of help to us?

Well, it's a tough issue, because you'll have to test every change to
see if it really makes a difference or not.
But you might try --disable-float8-byval, --disable-spinlocks. On the
compiler front (CFLAGS), you should have -mtune=54418 (or perhaps
-mtune=cfv4) (-march and -mcpu don't imply -mtune), and even perhaps
-O2 or -O3.

I also see you're specifying -msoft-float. So that's probably your
problem, any floating point arithmetic you're doing is killing you.
But without access to the software in order to change the data types,
you're out of luck in that department.

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Postgress is taking lot of CPU on our embedded hardware.
Next
From: Mark Kirkwood
Date:
Subject: Re: Postgress is taking lot of CPU on our embedded hardware.