this post was submitted on 09 Jun 2023
8 points (100.0% liked)

Sysadmin

7566 readers
1 users here now

A community dedicated to the profession of IT Systems Administration

No generic Lemmy issue posts please! Posts about Lemmy belong in one of these communities:
[email protected]
[email protected]
[email protected]
[email protected]

founded 1 year ago
MODERATORS
 

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 @[email protected] for creating this community!

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 1 points 1 year ago* (last edited 1 year ago) (1 children)

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.

[–] [email protected] 1 points 1 year ago (1 children)
[–] [email protected] 0 points 1 year ago (1 children)

I'm curious, how have the numbers changed in the last few weeks?

[–] [email protected] 1 points 1 year ago (1 children)

Well we use a new server now, with 32 core/64 threads and 128GB RAM. So quite some more..

[–] [email protected] 1 points 1 year ago

haha that's awesome! keep up the good work.