shared buffers

From: Greg Rychlewski <greg(dot)rychlewski(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: shared buffers
Date: 2021-03-29 15:27:21
Message-ID: CAKemG7UgmsEQUmD74_CCKy5ahyEd8yWSt-Nr7BXNcZ=MKSLcRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Laurenz Albe 2021-03-29 17:09:02 Re: shared buffers
Previous Message Simon Connah 2021-03-29 14:28:34 Re: Application trying to use wrong user when logging into the database