Hello to everybody,
I have this situation that I would to know your opinions about it, to
confirm some elements that secure me of use the amazing database
system PostgreSQL.
I have a database of 1000 tables, 300 of theirs are of major growing
with 10000 rows daily, the estimate growing for this database is of
2,6 TB every year.
There are accessing 5000 clients to this database of which will be
accessed 500 concurrent clients at the same time.
There are the questions:
1. Is capable PostgreSQL to support this workload? Some examples
better than this.
2. It is a recommendation to use a cluster with load balancer and
replication for this situation? Which tools are recommended for this
purpose?
3. Which are the hardware recommendations to deploy on servers? CPU,
RAM memory capacity, Hard disk capacity and type of RAID system
recommended to use among others like Operating System and network
connection speed.
Greetings and thanks a lot.