Home > mailing lists

shared buffers - Mailing list pgsql-novice

From	Greg Rychlewski
Subject	shared buffers
Date	March 29, 2021 18:27:21
Msg-id	CAKemG7UgmsEQUmD74_CCKy5ahyEd8yWSt-Nr7BXNcZ=MKSLcRg@mail.gmail.com Whole thread Raw
Responses	Re: shared buffers
List	pgsql-novice

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?

From: Simon Connah
Date: 29 March 2021, 17:28:34
Subject: Re: Application trying to use wrong user when logging into the database

From: Laurenz Albe
Date: 29 March 2021, 20:09:02
Subject: Re: shared buffers