PostgreSQL 10 High Performance - Third Edition

CPUs

Currently, available processors are bundling at least 2, and possibly as many as 22, cores into each CPU, making the core count the figure of merit for most database applications and, with PostgreSQL 10.x, we can use multiple cores for every single query with the mechanism called parallel query.

There are two basic decisions you need to make while deciding which CPU solution would best match your database application:

• Which processor family? Nowadays, this normally boils down to choosing between the various 64-bit product lines from Intel or Advanced Micro Devices (AMD), although there are some other less popular choices still floating around (Itanium, Scalable Processor Architecture (SPARC), and so on).
• Do you get more cores or faster ...