Re: Effective Cache Size
От
Manfred Koizar
Тема
Re: Effective Cache Size
Дата
Msg-id
a9j3gvgg2r7idrmfu7st9h8odc7pogq2lj@4ax.com
Ответ на
Effective Cache Size (Howard Oblowitz)
Список
Дерево обсуждения
Effective Cache Size Howard Oblowitz <HowardO@LEWIS-STORES.com>
Re: Effective Cache Size "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
Re: Effective Cache Size Manfred Koizar <mkoi-pg@aon.at>
Re: Effective Cache Size "scott.marlowe" <scott.marlowe@ihs.com>
On Tue, 1 Jul 2003 15:50:14 +0200 , Howard Oblowitz wrote: >What then will be the effect of setting this too high? The planner might choose an index scan where a sequential scan would be faster. >And too low? The planner might choose a sequential scan where an index scan would be faster. >How does it impact on other applications eg Java ? It doesn't -- at least not directly. (There could be very subtle effects when Postgres does a sequential scan over a large relation thus pushing everything else out of the cache, where an index scan would have read only a small number of pages. Or when a large index scan turns your machine from CPU bound to I/O bound.) Servus Manfred
В списке pgsql-performance по дате отправления
