I'll leave the "can/cannot" responses to those more familiar with high-load/use situations but I am curious; what reasons other than cost are leading you to discontinue using your current database engine? With that many entities any migration is likely to be quite challenging even if you restricted initial development to standard SQL. My estimate is that it is possible that PostgreSQL would meet your needs - though as you say the use of various tools to connection pool and such are going to be critical. As for recommendations - buy as much hardware as you can afford. David J. -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Rayner Julio Rodríguez Pimentel Sent: Wednesday, March 02, 2011 10:41 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: I need your help to get opinions about this situation 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
