Re: Bug: Buffer cache is not scan resistant - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug: Buffer cache is not scan resistant
Date
Msg-id 27070.1173158960@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug: Buffer cache is not scan resistant  ("Luke Lonergan" <llonergan@greenplum.com>)
List pgsql-hackers
"Luke Lonergan" <llonergan@greenplum.com> writes:
> Here's the x86 assembler routine for Solaris:
> http://cvs.opensolaris.org/source/xref/onnv/onnv-gate/usr/src/uts/intel/ia32
> /ml/copy.s
> The actual uiomove routine is a simple wrapper that calls the assembler
> kcopy or xcopyout routines.  There are two versions (for Opteron), one that
> uses the NTA instructions that bypass the L2 cache on writing to avoid L2
> cache pollution, and the second writes normally - through the L2 cache.

Hm.  If it were bypassing the L2 cache then the hit would be taken when
PG later tries to read the data.  This is clearly not what's happening
in the Linux system, but I've not seen any oprofile-equivalent data for
Solaris?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PL/Python warnings in CVS HEAD
Next
From: "Pavel Stehule"
Date:
Subject: Re: proposal: custom variables management