Re:Your data fits in RAM
by nierman on Thursday May 21, 2015 @10:26PM
(#9586363)
shared_buffers is the setting you're thinking of here.
effective_cache_size should be set to a reasonable value of course, but it does not affect the allocated cache size, it's just used by the query optimizer.
effective_cache_size should be set to a reasonable value of course, but it does not affect the allocated cache size, it's just used by the query optimizer.