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


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Nextcloud
  3. Nextcloud PostgreSQL high cpu usage

Nextcloud PostgreSQL high cpu usage

Scheduled Pinned Locked Moved Nextcloud
4 Posts 2 Posters 890 Views 2 Watching
  • 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 Offline
      E Offline
      el_pistolero
      wrote on last edited by
      #1

      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,

      girishG 1 Reply Last reply
      0
      • E el_pistolero

        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,

        girishG Offline
        girishG Offline
        girish
        Staff
        wrote on last edited by
        #2

        @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
        0
        • girishG Offline
          girishG Offline
          girish
          Staff
          wrote on last edited by
          #3

          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
          0
          • girishG girish moved this topic from Support on
          • girishG girish

            @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 Offline
            E Offline
            el_pistolero
            wrote on last edited by
            #4

            @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
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • Bookmarks
              • Search