On Wed, May 15, 2019 at 10:31 AM Andres Freund <andres@anarazel.de> wrote:
> *Without* disabling SMT, for readonly pgbench, I'm seeing regressions
> between 7-11%, depending on the size of shared_buffers (and some runtime
> variations). That's just on my laptop, with an i7-6820HQ / Haswell CPU.
> I'd be surprised if there weren't adversarial loads with bigger
> slowdowns - what gets more expensive with the mitigations is syscalls.
Yikes. This all in warm shared buffers, right? So effectively this
is the cost of recvfrom() and sendto() going up? Did you use -M
prepared? If not, there would also be a couple of lseek(SEEK_END)
calls in between for planning... I wonder how many more
syscall-taxing mitigations we need before relation size caching pays
off.
--
Thomas Munro
https://enterprisedb.com