I need your help to get opinions about this situation
От | Rayner Julio Rodríguez Pimentel |
---|---|
Тема | I need your help to get opinions about this situation |
Дата | |
Msg-id | AANLkTimnNpA=dM+Hzr-jCa-Sg5Q3mfGbTuBM6GDeCx0c@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: I need your help to get opinions about this situation
Re: I need your help to get opinions about this situation |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: