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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Rayner Julio
Rodríguez Pimentel
Sent: Wednesday, March 02, 2011 10:41 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] 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@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general