I have a server clone that i use for development. It has SuSE Linux v10 and a PostgreSQL back-end.
for a few months since it was created everytihng worked smoothly, but a few days ago, without any known trigger, a problem showed up. the server started to respond realy slow, and when i took a closer look, it seems that the cause is the postgres service. it eats 99,9% of CPU.
does anybody have any ideea why?
It might be relevant to say that another clone of the same server started behave in the same way in preety much the same time.
And that server was rarely used.
Do users have the ability to submit ad-hoc queries?
What version of Postgresql are you using?
the fact that both servers are having the same problem would indicate that something outside the servers are likely the underlying cause...
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert