Jaime Rodriguez wrote:
hi,
Today is my first day looking at PostgreSQL
I am looking to migrate a MS SQL DB to PostgreSQL :) :)
My customer requires that DBMS shall support 4000 simultaneous requests
thats a lot of connections and processes.
4000 concurrent queries will be generating a massive IO workload, what
sort of storage system are you planning on using?
4000 sockets from clients making simulatneous queries will generate a
massive network workload. what sort of networks are you using?
Also the system to be deploy maybe a cluster, with 12 microprocessors
a single server with 12 CPU cores, no problem.
12 separate servers, you're going to have to resolve some very sticky
issues with transactional integrity of updates and conflict resolution.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
