Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Index Only Scan vs Cache
Date
Msg-id 23068.1436463717@sss.pgh.pa.us
Whole thread Raw
In response to Index Only Scan vs Cache  (Andy Colson <andy@squeakycode.net>)
Responses Re: Index Only Scan vs Cache  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: regexp_matches for digit
Next
From: "Sheena, Prabhjot"
Date:
Subject: How to get total count of queries hitting DB per day or per hour?