Re: Index Only Scan vs Cache

From: Andy Colson <andy(at)squeakycode(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Index Only Scan vs Cache
Date: 2015-07-09 18:06:57
Message-ID: 559EB841.6010603@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/9/2015 12:41 PM, Tom Lane wrote:
> Andy Colson <andy(at)squeakycode(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2015-07-09 18:10:25 Re: How to get total count of queries hitting DB per day or per hour?
Previous Message Sheena, Prabhjot 2015-07-09 18:04:02 How to get total count of queries hitting DB per day or per hour?