Hyperthreading, vector width, clock speed, and more all impact how Postgres performs.
Here's how to choose:
Hyperthreading, vector width, clock speed, and more all impact how Postgres performs.
Here's how to choose:
This happens on CPUs too - disabling hyperthreading etc.
This happens on CPUs too - disabling hyperthreading etc.
Scale 100, -S -M prepared, each client count run for 15s, on a 2x Xeon Gold 6442Y workstation.
Scale 100, -S -M prepared, each client count run for 15s, on a 2x Xeon Gold 6442Y workstation.
Wait a minute, I can run this experiment by disabling all but one CPU core, and turning off hyperthreading!
Wait a minute, I can run this experiment by disabling all but one CPU core, and turning off hyperthreading!
and has 24 cores
my 7700K has 4 with hyperthreading and that still feels like a lot to me
and has 24 cores
my 7700K has 4 with hyperthreading and that still feels like a lot to me
#AiCompute #DiamondRapids #HotChips #Hpc #Intel #PcieGen6 #Server #Xeon
#AiCompute #DiamondRapids #HotChips #Hpc #Intel #PcieGen6 #Server #Xeon
echo off | sudo tee /sys/devices/system/cpu/smt/control
🛠️ podostack.com/p/hyperthre...
echo off | sudo tee /sys/devices/system/cpu/smt/control
🛠️ podostack.com/p/hyperthre...
SMT off. Every capacity model says that's the wrong direction.
podostack.com/p/hyperthre...
SMT off. Every capacity model says that's the wrong direction.
podostack.com/p/hyperthre...
This better be worth it.
This better be worth it.
what i mean by that is that my brain cannot multi-task in the sense that I can't actually do 2 things at once easily, but I can hold about 3-4 different ongoing tasks in my mind and switch between them very rapidly (hyperthreading) to appear so
what i mean by that is that my brain cannot multi-task in the sense that I can't actually do 2 things at once easily, but I can hold about 3-4 different ongoing tasks in my mind and switch between them very rapidly (hyperthreading) to appear so
I am more productive, better at hyperthreading tasks, and more ANNOYING! truly unstoppable.
I am more productive, better at hyperthreading tasks, and more ANNOYING! truly unstoppable.