Increase default effective_cache_size?
| От | Tom Lane | 
|---|---|
| Тема | Increase default effective_cache_size? | 
| Дата | |
| Msg-id | 29442.1159053033@sss.pgh.pa.us обсуждение исходный текст | 
| Ответы | Re: Increase default effective_cache_size? Re: Increase default effective_cache_size? Re: Increase default effective_cache_size? | 
| Список | pgsql-hackers | 
Russ Brown <pickscrape@gmail.com> writes on pgsql-general:
> On Thu, 2006-09-21 at 23:39 -0400, Jim Nasby wrote:
>> Also make sure that you've set effective_cache_size  
>> correctly (I generally set it to total memory - 1G, assuming the  
>> server has at least 4G in it).
> Thank you: the problem was the effective_cache_size (which I hadn't
> changed from the default of 1000). This machine doesn't have loads of
> RAM, but I knocked it up to 65536 and now the query uses the index,
> without having to change the statistics.
Considering recent discussion about how 8.2 is probably noticeably more
sensitive to effective_cache_size than prior releases, I wonder whether
it's not time to adopt a larger default value for that setting.  The
current default of 1000 pages (8Mb) seems really pretty silly for modern
machines; we could certainly set it to 10 times that without problems,
and maybe much more.  Thoughts?
        regards, tom lane
		
	В списке pgsql-hackers по дате отправления: