On Tue, Mar 17, 2026 at 02:54:29PM +0100, Tomas Vondra wrote:
!
! BTW the first thing I'd try is testing memory with memtest86+ or a
! similar tool. I don't know what hardware you're using, but I recently
! dealt with weird failures on older machines, and it turned out to be
! faulty RAM modules.
Yes, I considered this as one of the first things, and then ruled
it out, because
A) this is a Haswell-Xeon EP, and not only does it have ECC, but I
have already seen it identify a bad stick on this very hardware,
B) given that we have address space randomization, and that the
postgres memory footprint is kept rather small here (it should
then use ZFS ARC), I consider it highly unlikely that a memory
defect would always hit at the very same code-line, and never
anywhere else or in a different program.
PMc
