My job has been Database Admin for the past 25 years, still is. But nowadays it’s more shifting to infrastructure and automation.

And of course I do some self-hosting… like lemmy.world and mastodon.world and many others…

Thank you @[email protected] for creating this community!

  • RuudOPAEnglish
    2·
    3 years ago
    du -sm *
2181	pictrs
1885	postgres
    • huojtkegEnglish
      1·
      3 years ago

      It seems a lot for little content. My experience tells me that Postgres is not going to scale well, some sort of NoSQL will be necessary.

      • RuudOPAEnglish
        1·
        3 years ago

        Why not? My mastodon DB is 200 GB, works fine.

        • huojtkegEnglish
          2·
          3 years ago

          It depends on many things like the number of tables, the indexes, etc… but Postgres doesn’t work well above 1 TB. Anyway, it will take several years to reach that point. Someone will figure out a solution.

          Thank you for the info. Do you have any link with the specs of your server, bandwidth, cpu/ram usage, statistics…? Anything that could help me to do the maths.

            • pcr3English
              1·
              3 years ago

              I’m curious, how have the numbers changed in the last few weeks?

              • RuudOPAEnglish
                2·
                3 years ago

                Well we use a new server now, with 32 core/64 threads and 128GB RAM. So quite some more…

                • pcr3English
                  1·
                  3 years ago

                  haha that’s awesome! keep up the good work.