Postgres Pro
Downloads
Home   >   mailing lists

Re: Index Only Scan vs Cache - Mailing list pgsql-general

From Andy Colson
Subject Re: Index Only Scan vs Cache
Date
Msg-id 559EB841.6010603@squeakycode.net
Whole thread Raw
In response to Re: Index Only Scan vs Cache  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Index Only Scan vs Cache  (Shujie Shang <sshang@pivotal.io>)
Re: Index Only Scan vs Cache  (Marc Mamin <M.Mamin@intershop.de>)
List pgsql-general
Tree view 
On 7/9/2015 12:41 PM, Tom Lane wrote:
> Andy Colson <andy@squeakycode.net> writes:
>> My question is:  Will PG cache only the index (assuming it can always do
>> an Index Only Scan), or will it cache the table as well?
>
> The table blocks would fall out of cache if they're never touched.
>
>             regards, tom lane
>
>

Sweet!  Thanks Tom.

pgsql-general by date:

Previous
From: "Sheena, Prabhjot"
Date:
Subject: How to get total count of queries hitting DB per day or per hour?
Next
From: Andy Colson
Date:
Subject: Re: How to get total count of queries hitting DB per day or per hour?