Varun Kacholia wrote:
>
> hi ,
> I wanted to know whether it would be beneficial if one increases the
> shared memory buffer size ? (BTW is it possible to increase it in pg
> ...i think it is fixed to 8k) alongwith increasing the number of shared
> memory buffers.
The buffer size allways has to be the same as the database block size.
The latter defaults to 8K, can be changed at compile time, requires an
initdb then and is not recommended anyway.
Of course is increasing the number of shared buffers beneficial. It
usually increases the buffer hit rate in turn, causing lesser IO
operations and thus increasing the overall performance. If you're
setting up a dedicated DB server, I'd suggest starting with half of the
physical RAM configured as shared buffers and experimenting from there.
If it's not a dedicated server, lower the amount of shared buffers
accordingly.
> curiously yours
> --
> ------
> Varun
> Do not kill time ... else time will kill you
Doesn't matter, it'll kill you anyway. Time is only natures way of
making sure that everything doesn't go wrong at once!
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #