News for hackers. Stuff that matters.
Re: Subtly Bad Things Linux May Be Doing To PostgreSQL by treenyc on Thursday April 03, 2014 @03:58AM (#7521482)
same here. Was a FreeBSD user, but find hard to find VM a few years ago that support FreeBSD, may switch back, if this issue is NOT addressed.
Re: Subtly Bad Things Linux May Be Doing To PostgreSQL by dfox on Thursday April 03, 2014 @11:01AM (#7523297)
First issue is relevant only on systems that have more than one NUMA node, which is probably every meaningful physical server and essentially no VM (at least on Xen, multiprocessor VMs are single NUMA node), as it does not make much sense to advertise NUMA topology to guest VMs.

Second issue is relevant for postgresql mostly only if you use very large shared_buffers which anyway is not recommended for general workloads. Writing page that exists on disk and was not read short time before is not especially common thing to do.

Re: Subtly Bad Things Linux May Be Doing To PostgreSQL by rodgerd on Thursday April 03, 2014 @04:44PM (#7526467)
NUMA can absolutely ping you in virtual servers, but without access to the hypervisor you'll never know why it's happening (JVMs straddling NUMA regions have caused me pain in the past, when the guest was split across memory regions).
Re: Subtly Bad Things Linux May Be Doing To PostgreSQL by dfox on Thursday April 03, 2014 @05:44PM (#7527093)
The point is that kernel inside VM guest knows nothing about NUMA, so it cannot do any kind of NUMA optimizations hence such optimizations cannot hurt performance as they do not happen at all.
Re: Subtly Bad Things Linux May Be Doing To PostgreSQL by rodgerd on Thursday April 03, 2014 @06:17PM (#7527368)
Actually, KVM can allow you to create NUMA domains inside the guest, for better or worse.
Re: Subtly Bad Things Linux May Be Doing To PostgreSQL by pjc50 on Thursday April 03, 2014 @04:45AM (#7521635)
If you're running in a VM, the VM may impose its own constraints on the disk write and virtual memory issues.