Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2008

    Unanswered: PostgreSQL slowing down server

    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.

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    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

  3. #3
    Join Date
    Nov 2003
    Provided Answers: 8
    You can enable logging for long running statements in Postgres.
    Using that, you can identify which statement is actually causing this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts