2015-07-14 11:59 GMT+02:00 Shujie Shang <[email protected]>: > Does PG has its own data cache? I don't think so. >
PG has own data cache - see shared_buffers Regards Pavel > I think PG just using the filesystem cache. > > On Fri, Jul 10, 2015 at 2:06 AM, Andy Colson <[email protected]> wrote: > >> On 7/9/2015 12:41 PM, Tom Lane wrote: >> >>> Andy Colson <[email protected]> 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 ([email protected]) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > >
