public inbox for [email protected]  

help / color / mirror / Atom feed

From: Soni M <[email protected]>
To: [email protected] <[email protected]>
Subject: OS cache management
Date: Wed, 6 Sep 2017 15:12:26 +0700
Message-ID: <CAAMgDXkDgmnnzdDtk1pOX473eLK=eQN+MnccncGHiNBAtiRnTw@mail.gmail.com> (raw)
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: OS cache management
  In-Reply-To: <CAAMgDXkDgmnnzdDtk1pOX473eLK=eQN+MnccncGHiNBAtiRnTw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox