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.