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 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.
I’m curious, how have the numbers changed in the last few weeks?
Well we use a new server now, with 32 core/64 threads and 128GB RAM. So quite some more…
haha that’s awesome! keep up the good work.