why can't I increase shared buffers to higher value?

Поиск
Список
Период
Сортировка
От Dino Vliet
Тема why can't I increase shared buffers to higher value?
Дата
Msg-id 266346.81533.qm@web51109.mail.yahoo.com
обсуждение исходный текст
Ответы Re: why can't I increase shared buffers to higher value?  (Bill Moran <wmoran@collaborativefusion.com>)
Re: why can't I increase shared buffers to higher value?  ("Brian A. Seklecki" <lavalamp@spiritual-machines.org>)
Список pgsql-general
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





Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get things done faster.

В списке pgsql-general по дате отправления:

Предыдущее
От: Rob Schall
Дата:
Сообщение: Differences in identical queries
Следующее
От: Bill Moran
Дата:
Сообщение: Re: why can't I increase shared buffers to higher value?