Thread: shared buffers
Hi, In the 7.4.5 version, the code is now trying to use a much larger value for shared_buffers. I can certainly set this to a lower number with the -B option. However, my guestion is: What is the performance issue with setting shared_buffers to something like 45? In doing some timing on my system, I cannot tell any difference with 45 versus 1000. Perhaps I am looking at the wrong performance criteria. Thanks, Glenn
Glenn Sullivan <glenn.sullivan@varianinc.com> writes: > What is the performance issue with setting shared_buffers to something like 45? > In doing some timing on my system, I cannot tell any difference with 45 versus 1000. What are you timing exactly? Almost every benchmark I've ever seen is much happier with shared_buffers of at least a few hundred. Otherwise you spend too much time copying data between kernel and user space. regards, tom lane