| From: | Shujie Shang <sshang(at)pivotal(dot)io> |
|---|---|
| To: | Andy Colson <andy(at)squeakycode(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Index Only Scan vs Cache |
| Date: | 2015-07-14 09:59:32 |
| Message-ID: | CAJrojKWfObgg515XsgstAjrjSz4HoxTLQyqcKJ-EWFNz1Y0Kbg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Does PG has its own data cache? I don't think so.
I think PG just using the filesystem cache.
On Fri, Jul 10, 2015 at 2:06 AM, Andy Colson <andy(at)squeakycode(dot)net> wrote:
> 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.
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2015-07-14 10:03:33 | Re: Index Only Scan vs Cache |
| Previous Message | Igor Stassiy | 2015-07-14 09:12:24 | Creating table with data from a join |