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.

[–] ruud 2 points 2 years ago (1 children)

du -sm *
2181	pictrs
1885	postgres

[–] huojtkeg 1 points 2 years ago (1 children)

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.

[–] ruud 1 points 2 years ago (1 children)

Why not? My mastodon DB is 200 GB, works fine.

[–] huojtkeg 2 points 2 years ago* (last edited 2 years 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.

[–] ruud 5 points 2 years ago (1 children)

[–] pcr3 1 points 1 year ago (1 children)

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

[–] ruud 2 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..

[–] pcr3 1 points 1 year ago

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