Chris Withers schrieb am 05.12.2018 um 12:42:
> So, interestingly, this box has 250GB memory in it, and even though
> I've set effective_cache_size to 200GB, I only see 9G of memory being
> used. How can I persuade postgres to keep more in memory?
effective_cache_size is a hint to the optimizer on how much data is to be expected to be cached (by the filesystem).
Only shared_buffers (and work_mem) will actually allocate memory from the operating system.
Thomas