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 @DarraignTheSane@lemmy.world for creating this community!

  • RuudOPEnglish
    0•2 years ago

    For now it’s 2GB. I hope we can use block storage soon. I use Wasabi for mastodon.world

    • @huojtkeg@lemmy.worldEnglish
      0•2 years ago

      Just Postgres or Postgres + Pics? Could you give me the number for Postgres? I’m thinking in hosting my server but I have concerns abot scalability and costs in the future.

      • RuudOPEnglish
        0•2 years ago
        du -sm *
2181	pictrs
1885	postgres
        • @huojtkeg@lemmy.worldEnglish
          0•2 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.

          • RuudOPEnglish
            0•2 years ago

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

            • @huojtkeg@lemmy.worldEnglish
              1•2 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.