Beware, effective_cache_size is NOT, as stated, "the amount of disk cache provided by the OS" It is a combination of shared_buffers and kernel cache size See h

Beware, effective_cache_size is NOT, as stated, "the amount of disk cache provided by the OS" It is a combination of shared_buffers and kernel cache size See https://www.postgresql.org/message-id/20181105120104.GA13769%40momjian.us https://www.postgresql.org/message-id/20181105120104.GA13769... This important configuration parameter is a too-often badly understood. IMHO it should be, at least on a server non dedicated to PG, periodically dynamically calculated by the engine.