Guest User!

You are not Sophos Staff.

Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 20 replies
  • Subscribers 2 subscribers
  • Views 26798 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Postgres process - high CPU load

mcLays
After upgrading ASG120 to 8.201 (now latest 8.202) CPU usage by process postgres increased very dramatically up to 90-100% in peak time. 
I disabled Executive Reporting, but no success.
RAM is 1GB (40-50% used)

What else should I try?


This thread was automatically locked due to age.
Parents
  • 0
    by the way - 

    the actual file I ended up modifying is "postgresql.conf.large", located in "/var/storage/pgsql/cfg/". Reason being that at system start-up the postgresql config file gets replaced by the "pgconftune.sh" script, which in turn gets called from the postgresql init script only when the "start" parameter is passed to teh init script.

    so - if you modify the postgresql.conf file directly, your changes will be undone the next time your system restarts...

    Martijn.
Reply
  • 0
    by the way - 

    the actual file I ended up modifying is "postgresql.conf.large", located in "/var/storage/pgsql/cfg/". Reason being that at system start-up the postgresql config file gets replaced by the "pgconftune.sh" script, which in turn gets called from the postgresql init script only when the "start" parameter is passed to teh init script.

    so - if you modify the postgresql.conf file directly, your changes will be undone the next time your system restarts...

    Martijn.
Children
No Data