Postgres Pro
Downloads
Home   >   mailing lists

[PERFORM] OS cache management - Mailing list pgsql-performance

From Soni M
Subject [PERFORM] OS cache management
Date
Msg-id CAAMgDXkDgmnnzdDtk1pOX473eLK=eQN+MnccncGHiNBAtiRnTw@mail.gmail.com
Whole thread Raw
Responses Re: [PERFORM] OS cache management
Re: [SPAM] [PERFORM] OS cache management
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: George Neuner
Date:
Subject: Re: [PERFORM] printing results of query to file in different times
Next
From: Marcin Barczynski
Date:
Subject: [PERFORM] Slow vacuum of GIST indexes, because of random reads on PostgreSQL 9.6