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!

  • MrPoopyButthole@lemmy.world
    link
    fedilink
    English
    arrow-up
    3
    ·
    1 year ago

    Systems and software engineer here. I’m curious how the Lemmy project plans on scaling media uploads. It doesn’t seem feasible to host on an instance server. Even Reddit had a problem with media over the years and some subs to this day enforce offloading media to third party.

    • Ruud@lemmy.worldOP
      link
      fedilink
      English
      arrow-up
      3
      ·
      1 year ago

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

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

          • 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.