Re: Postgress is taking lot of CPU on our embedded hardware.
От
Claudio Freire
Тема
Re: Postgress is taking lot of CPU on our embedded hardware.
Дата
Msg-id
CAGTBQpZSNqR+__+aEFmrtTK22O39cCDL0N6SNBDkiZ-baN0rHQ@mail.gmail.com
Ответ на
Re: Postgress is taking lot of CPU on our embedded
hardware. (Jayashankar K B)
Список
Дерево обсуждения
Postgress is taking lot of CPU on our embedded hardware. Jayashankar K B <Jayashankar.KB@lnties.com>
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. Andy Colson <andy@squeakycode.net>
Re: Postgress is taking lot of CPU on our embedded
hardware. Jayashankar K B <Jayashankar.KB@lnties.com>
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. Jayashankar K B <Jayashankar.KB@lnties.com>
Re: Postgress is taking lot of CPU on our embedded hardware. Marti Raudsepp <marti@juffo.org>
Re: Postgress is taking lot of CPU on our embedded hardware. Claudio Freire <klaussfreire@gmail.com>
Re: Postgress is taking lot of CPU on our embedded
hardware. Jayashankar K B <Jayashankar.KB@lnties.com>
Re: Postgress is taking lot of CPU on our embedded hardware. Jose Ildefonso Camargo Tolosa <ildefonso.camargo@gmail.com>
Re: Postgress is taking lot of CPU on our embedded hardware. Deron <fecastle@gmail.com>
Re: Postgress is taking lot of CPU on our embedded hardware. Claudio Freire <klaussfreire@gmail.com>
Re: Postgress is taking lot of CPU on our embedded hardware. Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
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. Scott Marlowe <scott.marlowe@gmail.com>
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=/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 по дате отправления
От: Jeff Janes
Дата:
От: Mark Kirkwood
Дата: