Earlier quoted context omitted.
> I've seen that message. It acknowledges the same problems: do-nothing problems over a local unix socket. The first set of numbers isn't actually unrealistic. Doing lots of primary key lookups over low latency links is fairly common. The "SELECT 1" benchmark obviously was just to show something close to the worst case.
> The first set of numbers isn't actually unrealistic. Doing lots of primary key lookups over low latency links is fairly common. Latency through loopback on my machine takes 0.07ms. Latency to the machine sitting next to me is 5ms. We're actually (and to think, today I trotted out that joke about what you call a group of nerds--a well, actually ) talking multiple orders of magnitude through which kernel traps are be…
Uh, latency in local gigabit net is a LOT lower than 5ms.
> We're actually (and to think, today I trotted out that joke about what you call a group of nerds--a well, actually) talking multiple orders of magnitude through which kernel traps are being amplified.
I've measured it through network as well, and the impact is smaller, but still large if you just increase the number of connections a bit.