When one thread blocks waiting on integer operations, the other thread on the shared pair can perform float operations. However, if both threads need float then they run at half of normal speed. [simplified, but hits the main concept])
Not true.
Consider the case of a single core with hyperthreading. (Which was the case when HT was first introduced.)
If both threads need float, then one runs, the other doesn't. If one needs float, another needs fixed, then both run.
Yes, statistically, it would be effectively 50% of the speed (for those two instructions) - VS 2 cores, though!.
But you only have ONE core.
Hyperthreading gives one core some additional throughput, which tends to work out to about a 20% boost overall.
In most modern processors, you have multiple cores, but it all comes down to the one-core case * n.
If you think that hyperthreading EVER "slows down" the processor, you are misunderstanding the concept. Hyperthreading does NOT introduce an additional core, but allows an additional operation to run simultaneously on what would be an otherwise-unused part of the core. Theoretically, this could be done with MORE than two functional units even.
Additional cores completely duplicate the CPU and it's functional/compute units. You should not equate hyperthreading with an additional core.
----
As a software developer working on backend database (among other things), I think IBM is about to knock one out of the park with this:
https://www.ibm.com/cloud/hyper-protect-dbaas
https://www.ibm.com/cloud/hyper-protect-services
Doesn't run on Intel servers. Doesn't run on AMD servers. Doesn't run on ARM servers. Runs on much more secure IBM Z-series mainframes. Setting aside that these have been designed with security in mind, how many Joe Hackers have one? If Amazon/Microsoft/Google start deploying IBM mainframes... IBM still wins.
Runs on these:
https://www.ibm.com/it-infrastructure/linuxone
Free in beta right now, about to test a PostgreSQL instance. For now, you can get an 8GB memory, 80GB disk Postgres instance for $0/month. I'm afraid once it comes out of beta it will be too rich for our blood, but can always hope. I'd imagine at least 50% higher, since it runs one primary and two failovers vs 1/1. But if it's anything close to the pricing for the regular Database for PostgreSQL pricing I will jump on it.