Re: freebsd & postgresql 7.1.3

>>>>> "YAK" == Yuri A Kabaenkov <sec(at)artofit(dot)com> writes:

YAK> May be i need to recompile my kernel, if yes what options should
YAK> i add?

YAK> And how my RAM depends on this values ?

Postgres tuning is basically all about shared memory segments. In
FreeBSD, you don't need to recompile your kernel. Just set the
appropriate sysctl variables. I do this in my /etc/sysctl.conf file:

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

on a machine with 512MB RAM doing nothing but PostgreSQL serving.
Adjust the numbers as you see fit, and as described in the tuning
sections of the documentation. The SEM values seem to be ok with
their defaults in the FreeBSD kernel.

Once you tune the kernel, then you need to tune Postgres to use the
added capacity.

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