Re: Setting effective_cache size

2019-01-31 Thread Laurenz Albe
Nandakumar M wrote: > According to https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server : > > > effective_cache_size should be set to an estimate of how much memory is > > available for disk caching by the operating system and within the database > > itself, after taking into account w

Re: Setting effective_cache size

2019-01-30 Thread Nandakumar M
On Thu, Jan 31, 2019 at 1:00 PM Nandakumar M wrote: > This is particularly confusing because in this thread Tom Lane says > the following > Missed to link the thread.. https://postgrespro.com/list/thread-id/1813920 Regards, Nanda

Setting effective_cache size

2019-01-30 Thread Nandakumar M
Hi, According to https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server : > effective_cache_size should be set to an estimate of how much memory is > available for disk caching by the operating system and within the database > itself, after taking into account what's used by the OS itse