![]() If you will have 50+ users, then 8+ cores are recommended. (This was NOT the case in PSQLv10 or older, which suffered from some limitations on multi‐core servers.) If you will have only a few users, then core count is not critical, and 4 should be more than enough. Just like a 4‐lane freeway can carry more cars than a 2‐lane road, having more cores will allow for better multi‐tasking on the database, allowing work from multiple users to be done in parallel. Number of Cores: The number of cores on a server is more related to throughput, not performance.The typical trend is higher clock speed will result in lower number of CPU per core, and lower amount of level 1 or 2 cache memory. ![]() Also, the amount of level 1 or 2 cache memory can affect the CPU performance as well. See "Number of Cores" below to see why more cores may help. Sometime you can get a higher clock speed CPU with lesser number of cores. On the other hand, you should also balance CPU speed against number of cores and the level 1 or 2 cache for the CPU. For best results, look at 2.2GHz or faster. As such, the faster the clock speed you can get, the better. CPU Clock Speed: A single user running a database on a server only needs one core, but needs a fast clock speed to get fast performance.So, let’s start with the key factors to consider when buying a database server:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |