Thread: why can't I increase shared buffers to higher value?
I have the following config but increasing the shared buffers to a value greater then 32 doesn't let the database server start (I want a value of 256MB there because I will have a giant table of 12 million rows which will be qeuried extremely).
I have a 3GB RAM amd64 system running freebsd 6.1 with:
Maintenance_work_mem is 32MB
Max_stack_depth is 3MB
Shared_buffers is 32MB
Temp_buffers is 8MB
Work_mem is 32MB
Max_fsm_pages is 204800
Max_connections is 3
And I am doing this:
sysctl -w kern.ipc.shmmax=1954311424
sysctl -w kern.ipc.shmall=16384
Whay is my shared buffer value not increasing?
Hope you can help me out or give me a few tips.
O yeah, I'm using version 8.2.3.
Thanks
I have a 3GB RAM amd64 system running freebsd 6.1 with:
Maintenance_work_mem is 32MB
Max_stack_depth is 3MB
Shared_buffers is 32MB
Temp_buffers is 8MB
Work_mem is 32MB
Max_fsm_pages is 204800
Max_connections is 3
And I am doing this:
sysctl -w kern.ipc.shmmax=1954311424
sysctl -w kern.ipc.shmall=16384
Whay is my shared buffer value not increasing?
Hope you can help me out or give me a few tips.
O yeah, I'm using version 8.2.3.
Thanks
Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get things done faster.
Dino Vliet <dino_vliet@yahoo.com> wrote: > > I have the following config but increasing the shared buffers to a value greater then 32 doesn't let the database serverstart (I want a value of 256MB there because I will have a giant table of 12 million rows which will be qeuried extremely). > > I have a 3GB RAM amd64 system running freebsd 6.1 with: > > Maintenance_work_mem is 32MB > Max_stack_depth is 3MB > Shared_buffers is 32MB > Temp_buffers is 8MB > Work_mem is 32MB > Max_fsm_pages is 204800 > Max_connections is 3 > > And I am doing this: > > sysctl -w kern.ipc.shmmax=1954311424 > sysctl -w kern.ipc.shmall=16384 > > Why is my shared buffer value not increasing? 16384 is only 130M. Try using 238000 for shmall. -- Bill Moran Collaborative Fusion Inc.
http://lists.freebsd.org/pipermail/freebsd-hackers/2006-December/018854.html ~BAS On Wed, 28 Feb 2007, Dino Vliet wrote: > I have the following config but increasing the shared buffers to a value greater then 32 doesn't let the database serverstart (I want a value of 256MB there because I will have a giant table of 12 million rows which will be qeuried extremely). I have a 3GB RAM amd64 system running freebsd 6.1 with: Maintenance_work_mem is 32MB Max_stack_depth is 3MB Shared_buffers is 32MB Temp_buffers is 8MB Work_mem is 32MB Max_fsm_pages is 204800 Max_connections is 3 And I am doing this: sysctl -w kern.ipc.shmmax=1954311424 sysctl -w kern.ipc.shmall=16384 Whay is my shared buffer value not increasing? Hope you can help me out or give me a few tips. O yeah, I'm using version 8.2.3. Thanks ____________________________________________________________________________________ Have a burning question? Go to www.Answers.yahoo.com and get answers from real people who know. l8* -lava (Brian A. Seklecki - Pittsburgh, PA, USA) http://www.spiritual-machines.org/ "...from back in the heady days when "helpdesk" meant nothing, "diskquota" meant everything, and lives could be bought and sold for a couple of pages of laser printout - and frequently were."