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