X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 213F6D1E8FB for ; Tue, 16 Mar 2004 18:54:47 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 82303-10 for ; Tue, 16 Mar 2004 14:54:40 -0400 (AST) Received: from mail2.dbitech.ca (radius.wavefire.com [64.141.13.252]) by svr1.postgresql.org (Postfix) with SMTP id 1A4B8D1E2D7 for ; Tue, 16 Mar 2004 14:54:37 -0400 (AST) Received: (qmail 20568 invoked from network); 16 Mar 2004 18:59:49 -0000 Received: from dbitech.wavefire.com (HELO 64.141.15.253) (darcy@64.141.15.253) by radius.wavefire.com with SMTP; 16 Mar 2004 18:59:49 -0000 From: Darcy Buskermolen Organization: Wavefire Technologies Corp. Subject: Fwd: Configuring disk cache size on postgress Date: Tue, 16 Mar 2004 10:54:35 -0800 User-Agent: KMail/1.5.4 To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200403161054.35616.darcy@wavefire.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/222 X-Sequence-Number: 6078 This apeared on the Freebsd-perfomace list and though people here could help as well. ---------- Forwarded Message ---------- Subject: Configuring disk cache size on postgress Date: March 16, 2004 10:44 am From: Dror Matalon To: freebsd-performance@freebsd.org Hi Folks, When configuring postgres, one of the variables to configure is effective_cache_size: Sets the optimizer's assumption about the effective size of the disk cache (that is, the portion of the kernel's disk cache that will be used for PostgreSQL data files). This is measured in disk pages, which are normally 8 kB each. (http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html) The conventional wisdom on the postgres list has been that for freebsd you calculate this by doing `sysctl -n vfs.hibufspace` / 8192). Now I'm running 4.9 with 2 Gig of ram and sysctl -n vfs.hibufspace indicates usage of 200MB. Questions: 1. How much RAM is freebsd using for *disk* caching? Is it part of the general VM or is it limited to the above 200MB? I read Matt Dillon's http://www.daemonnews.org/200001/freebsd_vm.html, but most of the discussion there seems to be focused on caching programs and program data. 2. Can I tell, and if so how, how much memory the OS is using for disk caching? 3. What are the bufspace variables for? This subject has been touched on before in http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2003-09/0045.html which point to a patch to increase the bufspace. Regards, Dror -- Dror Matalon Zapatec Inc 1700 MLK Way Berkeley, CA 94709 http://www.fastbuzz.com http://www.zapatec.com _______________________________________________ freebsd-performance@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "freebsd-performance-unsubscribe@freebsd.org" ------------------------------------------------------- -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com