Steve wrote:
Common wisdom in the past has been that values above a couple of hundred
MB will degrade performance.
The annotated config file talks about setting shared_buffers to a third
of the
available memory --- well, it says "it should be no more than 1/3 of the
total
amount of memory" (quoting off the top of my head). Don't recall seeing
any warning about not exceeding a few hundred megabytes.
My eternal curiosity when it comes to this memory and shared_buffers thing:
How does PG take advantage of the available memory? I mean, if I have a
machine with, say, 4 or 8GB of memory, how will those GBs would end
up being used? They just do?? (I mean, I would find that a vaild
answer;
but I ask, because this configuration parameters stuff makes me think that
perhaps PG does not simply use whatever memory is in there, but it has
to go through the parameters in the config file to allocate whatever it has
to use).
So, is it just like that? We put more memory and PG will automatically
make use of it?
Carlos
--
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend