Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Nextcloud PostgreSQL high cpu usage

    Nextcloud
    2
    4
    274
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • E
      el_pistolero last edited by

      Hello to the Cloudron community,

      We have a problem with Cloudron and Nextcloud. Nextcloud is continuously very very slow and this during the whole day. After analyzing the logs and statistics in real time, it appears that the postgre content consumes a lot of cpu (often in overload up to 395%).

      Have you ever seen this? If so, do you have a solution?

      Server infos :
      CPU : E3-1225v2 (4c/4t)
      Ram : 16GB DDR3
      HDD : softRaid 2x2ToC

      Cloudron V : 6.1.2
      Nextcloud V : 22.2.3

      Nbr of users : 124

      Users are usually connected via the desktop client with hard or virtual file synchronization (50/50).

      Thank you for your feedback

      Regards,

      girish 1 Reply Last reply Reply Quote 0
      • girish
        girish Staff @el_pistolero last edited by

        @el_pistolero I feel I have seen this before. Usually to do with large oc_filecache . How many entries do you have in that table?

        E 1 Reply Last reply Reply Quote 0
        • girish
          girish Staff last edited by

          Maybe related - https://help.nextcloud.com/t/high-postgresql-cpu-usage-on-nextcloud-server/124958 . Also, https://github.com/nextcloud/server/issues/15995 suggests maybe plugins also influence high CPU . What plugins do you have enabled on your nextcloud install?

          1 Reply Last reply Reply Quote 0
          • Moved from Support by  girish girish 
          • E
            el_pistolero @girish last edited by

            @girish Hi, thx for answer.

            Queston for dummies like me, did you order it to see the number of entries in postgre?

            Sorry, I'm not familiar with postgre. 😧

            1 Reply Last reply Reply Quote 0
            • First post
              Last post
            Powered by NodeBB