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!

    • huojtkeg@lemmy.world
      link
      fedilink
      English
      arrow-up
      1
      ·
      1 year 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.

        • huojtkeg@lemmy.world
          link
          fedilink
          English
          arrow-up
          1
          ·
          edit-2
          1 year 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.