Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2009
    Posts
    1

    Unanswered: PostgreSQL - Using all resources

    Hey guys,

    I have a pretty old linux server running Red Hat 6.2. This server runs software that controls billing and accounts for my dialup clients. This is all good and well however lately it appears that the PostgreSQL service is using all the system resources. Upgrading to a newer version of my linux isnt really an option. Any help regarding this issue would be greatly appricated.

    Thanks alot

    PS. I have very limted knowledge and experiance with linux, however I have contractors that normally service my linux box but they have no experiance with postgreSQL.

  2. #2
    Join Date
    Sep 2009
    Posts
    64
    If you're not doing it, maybe you should try to periodically vacuum the table using CRON job or something.

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    You don't say what version of PostgreSQL you're using.
    Lou
    使大吃一惊
    "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


Posting Permissions

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