Re: [GENERAL] heavy load-high cpu itilization

2011-07-27 Thread Greg Smith
On 07/27/2011 04:37 AM, Filippos wrote: P.S i will send a message to the admins, to ask them to move the topic to the sub-forum of perfomance Don't do that; will just waste their time. pgsql-general is a mailing list, and the "forum" view you're seeing at Nabble is just a web interface t

Re: [GENERAL] heavy load-high cpu itilization

2011-07-27 Thread Filippos
thx a lot for your answer. i have already bought your book and have read most of the chapters. (in the near future i will study it more thoroughly) i asked here for tips in case there was something i had missed and there was a "magic" way to improve the perfomance even a little. as far as the

Re: [GENERAL] heavy load-high cpu itilization

2011-07-26 Thread Greg Smith
On 07/26/2011 01:47 PM, Filippos wrote: we have a dedicated server (8.4.4, redhat) with 24 cpus and 36 GB or RAM. i would say that the traffic in the server is huge and the cpu utilization is pretty high too (avg ~ 75% except during the nights when is it much lower). i am trying to tune the serve