Re: postgres 7.1.1 on Freebsd 4.3?

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: postgres 7.1.1 on Freebsd 4.3?
Дата
Msg-id x7vggnlqvu.fsf@onceler.kciLink.com
обсуждение исходный текст
Ответ на postgres 7.1.1 on Freebsd 4.3?  ("Rudy Amid" <radix33@hotmail.com>)
Список pgsql-general
>>>>> "RA" == Rudy Amid <radix33@hotmail.com> writes:

RA> The Postgres FAQ states that my kernel may not have enough (~10Mb)
RA> of shared memory, but to my dismay, I also can't figure out how to
RA> tweak that on the freebsd kernel config.

No need for a new kernel. Just use sysctl to set the value at runtime,
like this, in your /etc/sysctl.conf file (create it if you don't have
one already)

# tuning for PostgreSQL
kern.ipc.shmall=65535
kern.ipc.shmmax=268435456
kern.ipc.shm_use_phys=1


You can run the above with, eg, "sysctl -w kern.ipc.shmall=65535" at
the command line as well, at any time.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

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

Предыдущее
От: Jeff Eckermann
Дата:
Сообщение: Re: self outer join
Следующее
От: "Brent R. Matzelle"
Дата:
Сообщение: Re: Perfomance Problems