OS cache management

From: Soni M <diptatapa(at)gmail(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: OS cache management
Date: 2017-09-06 08:12:26
Message-ID: CAAMgDXkDgmnnzdDtk1pOX473eLK=eQN+MnccncGHiNBAtiRnTw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello All, I would like to know about how OS cache works for postgres table
and index file.

Let's say I have 10 year data, and commonly used data only the last 1 year.
This data is quite big, so each table and index file is divided into
several file in PGDATA/base

Let's say 1 index named order_by_date has relfilenode = 1870772348, and
it's file consist of 1870772348, 1870772348.1, and 1870772348.2

And for oftenly queried 1 year data, do ALL files for the order_by_date
pushed to OS cache ? or it's just 1 file that contains index to this 1 year
data.

How about index named order_by_customer, will ALL the index files pushed to
OS cache ?

Can someone please explain about how OS cache works for this condition.

Thanks very much for the explanation.

--
Regards,

Soni Maula Harriz

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Marcin Barczynski 2017-09-06 11:57:25 Slow vacuum of GIST indexes, because of random reads on PostgreSQL 9.6
Previous Message George Neuner 2017-09-05 17:12:24 Re: printing results of query to file in different times