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

[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

[PERFORM] enable database user login/logout information

2011-06-09 Thread muthu krishnan
Hi, We are running postgresql database server on itanium box. Database - Postgresql 8.3.9 OS - SUSE Linux 11 SP 3 Server - Itanium (ia64) We are trying to enable user login / logout information in postgresql log file, to do this we enabled the following in postgresql.conf, log_connections = on