MIME-Version: 1.0
From: Greg Rychlewski <greg.rychlewski@gmail.com>
Date: Mon, 29 Mar 2021 11:27:21 -0400
Message-ID: 
 <CAKemG7UgmsEQUmD74_CCKy5ahyEd8yWSt-Nr7BXNcZ=MKSLcRg@mail.gmail.com>
Subject: shared buffers
To: pgsql-novice@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001577c405beae8c70"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKemG7UgmsEQUmD74_CCKy5ahyEd8yWSt-Nr7BXNcZ%3DMKSLcRg%40mail.gmail.com>
Precedence: bulk

--0000000000001577c405beae8c70
Content-Type: text/plain; charset="UTF-8"

Hi,

Will every page touched during a table or index scan, even if it's not
going to be used in the final result, be loaded into shared buffers?

i.e. if you need to evaluate a filter condition, will it load that page
into shared buffers and then evaluate it from there?

--0000000000001577c405beae8c70
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>Will every page touched during a ta=
ble or index scan, even if it&#39;s not going to be used in the final resul=
t, be loaded into shared buffers?=C2=A0</div><div><br></div><div>i.e. if yo=
u need to evaluate a filter condition, will it load that page into shared b=
uffers and then evaluate it from there?</div></div>

--0000000000001577c405beae8c70--