On 29/04/2010 10:04 AM, Greg Smith wrote:
Jaime Rodriguez wrote:
My customer requires that DBMS shall support 4000 simultaneous requests
Also the system to be deploy maybe a cluster, with 12 microprocessors
[snip]
If most connections are read-only, there are a few ways to design a
cluster of systems to support the sort of design needed to scale up to
where you're aiming at. Getting more than one node you can write to in a
cluster is much harder.
If most of the connections are read-only then in addition to using a
connection pooler and/or read slave cluster, you can look into getting
the customer to using memcached as a midlayer. They should see a huge
performance boost if they're prepared to do the work.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
