Re: [PERFORM] Postgresql on itanium server

2011-06-09 Thread Tom Lane
Jochen Erwied writes: > Thursday, June 9, 2011, 12:45:06 PM you wrote: >> As the URL mentions, you can build with CFLAGS=-ffast-math, that >> should work for PostgreSQL too. > I just tried this with the source for 9.0.4, at least with this version the > build will not complete since there is a ch

Re: [PERFORM] Postgresql on itanium server

2011-06-09 Thread Jochen Erwied
Thursday, June 9, 2011, 12:45:06 PM you wrote: > As the URL mentions, you can build with CFLAGS=-ffast-math, that > should work for PostgreSQL too. I just tried this with the source for 9.0.4, at least with this version the build will not complete since there is a check in src/backend/utils/adt/d

Re: [PERFORM] Postgresql on itanium server

2011-06-09 Thread Marti Raudsepp
On Thu, Jun 9, 2011 at 13:03, muthu krishnan wrote: > Thank you for suggesting the valuable URL, we are getting 3 "floating point > assist fault" error for every second, will it impact the performance for > postgresql? Probably. The kernel throttles these messages, so you're probably performing

Re: [PERFORM] Postgresql on itanium server

2011-06-09 Thread Jochen Erwied
Thursday, June 9, 2011, 12:03:12 PM you wrote: > Is there any option to turn on "flush to zero mode" in itanium cpu while > compiling postgresql from source? configure will complain when specifying './configure CFLAGS=-ffast-math'. make won't, so a 'make CFLAGS='-O2 -Wall -ffast-math' after doin

Re: [PERFORM] Postgresql on itanium server

2011-06-09 Thread muthu krishnan
Dear Jochen, Thank you for suggesting the valuable URL, we are getting 3 "floating point assist fault" error for every second, will it impact the performance for postgresql? Is there any option to turn on "flush to zero mode" in itanium cpu while compiling postgresql from source? Thank you for y

Re: [PERFORM] Postgresql on itanium server

2011-06-09 Thread Jochen Erwied
Thursday, June 9, 2011, 11:20:33 AM you wrote: > *Jun 9 04:45:42 kernel: postmaster(31965): floating-point assist fault at > ip 403dad71, isr 0208* A quick search for 'floating-point assist fault' reveals this article: http://h21007.www2.hp.com/portal/site/dspp/menuitem.863c

[PERFORM] Postgresql on itanium server

2011-06-09 Thread muthu krishnan
Hi, We have installed postgresql on itanium server (HP rx7640), only on this server we are getting the following error in /var/log/messages and also the postgres performance is very slow. Error: *Jun 9 04:45:42 kernel: postmaster(31965): floating-point assist fault at ip 403dad71, isr 0