If shmmax and shmmall are too small, then:
PostgreSQL requires some more shared memory to cache some tables, x
Mb, do you want to increase your OS kernel parameters?
Tweak shmmax and shmmall

CK> Note that this still requires a kernel recompile on FreeBSD :(

According to whom?  sysctl is your friend.  Some sysctl settings may
require reboot, but I don't think the SHM ones do.

Hmmm...you may be right - I can't prove it now...

houston# sysctl -w kern.ipc.shmmax=99999999999
kern.ipc.shmmax: 33554432 -> 2147483647

Hrm. Ok. Maybe they've changed that in some recent version :)


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to