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!
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.
Why not? My mastodon DB is 200 GB, works fine.
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.