Hola Lista, Estamos planeando hacer una mejora en el Numero de CPU the los servidores y me surge la siguiente pregunta. Cual es el numero correcto de CPU que debemos utilizar en la configuration de postgres?
Tomemos the ejempl el CPU que estoy usando: CPU(s): 32 On-line CPU(s) list: 0-31 Thread(s) per core: 2 Core(s) per socket: 8 Socket(s): 2 NUMA node(s): 1 Vendor ID: GenuineIntel CPU family: 6 Model: 63 Model name: Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz Supuestamente tengo 32 CPU, pero si nos fijamos tengo 8 cores y 2 sockets, por lo que en realidad tengo 16 CPU, ahora cuando multiplicamos los 16 CPU por el numero the threads ,e da 32, pero leyendo un poco al respecto me encontre esto: Hyper-threading is where your processor pretends to have 2 physical processor cores, yet only has 1 and some extra junk. The point of hyperthreading is that many times when you are executing code in the processor, there are parts of the processor that is idle. By including an extra set of CPU registers, the processor can act like it has two cores and thus use all parts of the processor in parallel. When the 2 cores both need to use one component of the processor, then one core ends up waiting of course. This is why it cannot replace dual-core and such processors. Entonces, cuando voy a configurar postgres debo usar 32 or 16, esta es mi configuration: max_worker_processes = 32 max_parallel_workers_per_gather = 16 Gracias de anteamo, Carlos
