Re: Index Only Scan vs Cache

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

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sheena, Prabhjot 2015-07-09 18:04:02 How to get total count of queries hitting DB per day or per hour?
Previous Message Ramesh T 2015-07-09 17:17:58 Re: regexp_matches for digit