This question has been flagged
2253 Views

When I click any form,its loading continuously..

I used htop command in terminal to see the process,its showing postgres using more than 90 % cpu.

How to rectify this problem.
 

Avatar
Discard

Are you in the possibility of doing a reboot? I'd try that to begin with. If problems then persis you should start checking how/when it happens and if the logs print anything out.

Author

Yeah everday morning i am restarting the server because of slowness.But its still continuous.Is ther anything i have to tune in postgres.

Thats not normal for sure. Have a look at the postgresql logfile if you find anything unusual.. The logfile is located under /var/log/postgresql/ and the file is named postgresql-9.x-main.log. Look if anything unusual pops up there.

Author

yeah I checked in var/log/postgresql/postgresql-9.x-main.log.It doesnt show any unusual pops.It happens when concurrent users access the server at a time.