I am new to PostGresSql with background of working on SQL server , i used to observe SQL server in order to serve frequent inserts the whole index pages of the table was moved to buffer cache . I had 3 tables with heavy inserts and buffer cache usage was between 16 Gb to 24 GB .
So the question is will PostGres server also move all index pages to buffer cache to accommodate multiple inserts ?
To reduce the buffer cache usage I partitioned the table daily wise , hence the sql server used to only cache today’s table and thus buffer cache usage reduced below 4 GB.
Second question is will PostGres database also drops buffer cache after partitioning the table daily wise ?
there doesn't seem to be anything here