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 cpu usage is concerned, i have monitored the situation closely (using top and other tools), and it comes from postgres. you also told me about the logs and i am aware of this "technique" but i didnt use it so far, to avoid the extra load of data, but i will do it soon. i will also schedule an update deal with the bug for autovacuum. thx again :) P.S i will send a message to the admins, to ask them to move the topic to the sub-forum of perfomance -- View this message in context: http://postgresql.1045698.n5.nabble.com/heavy-load-high-cpu-itilization-tp4635696p4637997.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
