I have a database with many small reference data tables and a few large time series tables. The reference data tables can easily fit into memory. I have various ETL jobs that load data, mainly by left joining incoming data onto the existing tables, and insert/update/delete where required.
Does it make sense to call
pg_prewarm on all the reference data tables after an ETL job has finished, so as to ensure that all of them are loaded into memory the next time an ETL load fires? Will I notice much of an improvement?
Assume that the memory is sufficiently large so as to not cause an issue with buffer eviction.