X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id DA3D2D1B503 for ; Mon, 13 Oct 2003 14:05:20 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 07158-03 for ; Mon, 13 Oct 2003 11:04:34 -0300 (ADT) Received: from yertle.kcilink.com (yertle.kcilink.com [216.194.193.105]) by svr1.postgresql.org (Postfix) with ESMTP id 0A97AD1B511 for ; Mon, 13 Oct 2003 11:04:31 -0300 (ADT) Received: by yertle.kcilink.com (Postfix, from userid 100) id 982DA2178C; Mon, 13 Oct 2003 10:04:35 -0400 (EDT) From: Vivek Khera MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <16266.45299.517752.465494@yertle.int.kciLink.com> Date: Mon, 13 Oct 2003 10:04:35 -0400 To: pgsql-performance@postgresql.org Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL In-Reply-To: <20031011092308.GA39942@perrin.nxad.com> References: <007901c38f2b$0b585590$2802a8c0@webbased10> <200310101034.52073.josh@agliodbs.com> <3F86F5BB.90605@chuckie.co.uk> <3F87932B.4050507@familyhealth.com.au> <20031011092308.GA39942@perrin.nxad.com> X-Mailer: VM 7.14 under 21.4 (patch 12) "Portable Code" XEmacs Lucid X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/421 X-Sequence-Number: 4169 >>>>> "SC" == Sean Chittenden writes: >> echo "effective_cache_size = $((`sysctl -n vfs.hibufspace` / 8192))" >> >> I've used it for my dedicated servers. Is this calculation correct? SC> Yes, or it's real close at least. vfs.hibufspace is the amount of SC> kernel space that's used for caching IO operations (minus the I'm just curious if anyone has a tip to increase the amount of memory FreeBSD will use for the cache? It appears to me that even on my 2Gb box, lots of memory is 'free' that could be used for the cache (bumping up shared buffers is another option...) yet the disk is being highly utilized according to systat.