Hi Devrim, Thanx for the help. Is there anyway to maximize the SHMMAX for the following M/C details : Release: 5.8 Kernel architecture: sun4u Application architecture: sparc Hardware provider: Sun_Microsystems Domain: Kernel version: SunOS 5.8 Generic 108528-17 September 2002
I tried cat /proc/sys/kernel/shmmax and it says cat: cannot open /proc/sys/kernel/shmmax As thers no sys directory in /proc/ . Thanx and regards Sidd -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Devrim GUNDUZ Sent: Monday, October 27, 2003 12:49 PM To: [EMAIL PROTECTED] Subject: Re: [ADMIN] Need your help -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Mon, 27 Oct 2003, Siddharth Rath (sirath) wrote: <snip> > at the end of 6th step I did receivethe following in my log file. I > cant reconfigure the kernel with larger SHMMAX. Please let me know how > can I reduce the request size (currently 1499136 bytes), reduce > PostgreSQL's shared_buffers parameter (currently 64) and/or > its max_connections parameter (currently 32). You do not need to reconfigure Linux kernel for a larger SHMMAX. As root, simply echo the new value into /proc/sys/kernel/shmmax: #echo 83886080 > /proc/sys/kernel/shmmax In the example above, we set the value of SHMMAX to 80 Mb. The change takes effect immediately but after a reboot, the original value is restored. If you put that line in /etc/rc.local (or equivalent), your system will set the SHMMAX value to the value you'll write there. If, one day, you need to reconfigure the kernel; then edit /usr/src/linux/include/asm/shmparam.h and recompile Linux. (maybe after reading http://www.linuxdoc.org/HOWTO/Kernel-HOWTO.html :) ) Regards, - -- Devrim GUNDUZ [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.tdmsoft.com http://www.gunduz.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE/nYTMtl86P3SPfQ4RAlM1AKCvvtQoQIAgnoXzB8/bG9KyjNnABACdGJBz OlT+4F3/3ntkWb/kgDxuJ/c= =7VLf -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend ---------------------------(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
