Hello friends!

Lemmy.ca will be undergoing scheduled maintenance from approximately 12:00 - 12:30 PT (3:00 - 3:30 ET), while we move to a more powerful server.

Happy Canada day!

    • ShadowOPMA
      link
      fedilink
      arrow-up
      2
      ·
      1 year ago

      Disk, due to low memory. Not enough to keep enough of the db in memory, and having to hit disk for pictures as well.

      • lightrush
        link
        fedilink
        arrow-up
        2
        ·
        1 year ago

        Oh I see. Makes sense. Do you know if the storage was NVMe previously or spinning media?

        • ShadowOPMA
          link
          fedilink
          arrow-up
          1
          ·
          edit-2
          1 year ago

          It was a VPS and I think on some sort of shared SATA/SAS SSD array, just going off the 300-800MB/s reads I was seeing.

          Old box: Timing buffered disk reads: 2066 MB in 3.00 seconds = 687.62 MB/sec

          New box: Timing buffered disk reads: 1022 MB in 0.31 seconds = 3338.77 MB/sec

          • lightrush
            link
            fedilink
            arrow-up
            1
            ·
            1 year ago

            Nice uplift. Random IO which is likely what the db does are probably through the roof compared to the sequential uplift.

            • ShadowOPMA
              link
              fedilink
              arrow-up
              2
              ·
              1 year ago

              The DB is small enough it’s all in ram now, seeing a 100% cache hit rate in postgres.

              • lightrush
                link
                fedilink
                arrow-up
                2
                ·
                1 year ago

                Nice. You could post any screenshots and copy-pasta if you collect them anyways from stuff you find interesting while working on the instance. I’m sure there’s a lot of technical folks around here other than us that would find it fun to look at. Only if it’s not significant additional work of course. 😁