Hi all,
Iam using postgresql 8.1.4 with 8GB physical RAM.
OS kernel max shared memory usage is set to( /proc/sys/kernel/shmmax) 33554432
dont know if this number is in bytes or bits
now how do i set my shared_buffer setting in postgresql.conf such that ican use
max shared memory setting of the kernel.
also default shared_buffer setting is 1000 - its not clear if i have to
multiply this number with 8KB to be <= max shared memory value or it is 1000
bytes or bits.
can i set the max shared memory value to use atleast half of my physicl RAM
available ?
any idea ?
also i would like to know how is the performance hit when we change
shared_buffer value in general ?
regards,
KM
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
