I'm planning to host a website. I'm assuming, with time, I may have 100,000 users 2-5% would be online at a time.
I'm planning to go for postgresql.
The data I'm expecting that users will upload will be binary files including photographs mostly and limited character texts.
Assuming 2000 users online and 1000 users uploading photographs and exchanging text messages what should be the server configuration should I need. I'm planning to take a static IP and buy own servers as of now.
Please comment, as I do not have much knowledge about web stuff. I can do it on a computer on a tomcat webserver, but how is it done at large scale, please advise.
Please comment of the decision of PostgreSql. What if number of users increased to more than expected, and things like that