>>>>> "JB" == Josh Berkus <[EMAIL PROTECTED]> writes:
JB> Chris, >> > 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 >> >> Note that this still requires a kernel recompile on FreeBSD :( JB> Not our fault, now is it? This would mean that we wouldn't be JB> able to script for FreeBSD. Bug the FreeBSD developers. "I read it on the net so it must be true" applies here. You /can/ set these values via sysctl calls. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
