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 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
____________________________________________________________________________________
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."
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
