Search Postgresql Archives

Re: Why facebook used mysql ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/9/2010 11:36 AM, Sandeep Srinivasa wrote:

If it is independent of the OS, then how does one go about tuning it.

Consider this - I get a 12 core server on which I want multiple webserver instances + DB. Can one create CPU pools (say core 1,2,3 for webservers, 4,5,6,7 for DB, etc.) ?

I know about taskset, but should one be using it ?

There are plenty of things you might do, but first you need to figure out what problem you're solving. I'd suggest deploying a relatively simple configuration then evaluate its capacity under your workload. Does it run fast enough? If so, then job done. If not then why not, and so on...

The simplest configuration would be one web server instance and one DB instance.

I don't think you should be looking at process partitioning and core affinity unless you have already proved that you have processes that don't scale over the cores you have, to deliver the throughput you need.



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux