Re: [GENERAL] shared_buffer setting

2006-10-06 Thread Talha Khan
Hi Km,   The shmmax setting is in *BYTES*.   Regards Talha Khan On 10/6/06, Talha Khan <[EMAIL PROTECTED]> wrote: Hi Km,   The shmmax setting is in bits.   For knowing the details about the shared_buffer settings and other configuration features follow the link given below:   http://www.powerpostg

Re: [GENERAL] shared_buffer setting

2006-10-06 Thread Talha Khan
Hi Km,   The shmmax setting is in bits.   For knowing the details about the shared_buffer settings and other configuration features follow the link given below:   http://www.powerpostgresql.com/PerfList   The shmmax value set in your kernel (i.e 33554432) seems quite low seeng that you have 8GB phy

[GENERAL] shared_buffer setting

2006-10-06 Thread km
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