Date: Tue, 28 Dec 2010 14:59:41 +0100 From: Nicolas Haller <nicolas.haller@corp.nerim.fr> To: freebsd-performance@freebsd.org Subject: tunning disk cache for pgsql? Message-ID: <20101228135940.GE2660@baneblade.noc.nerim.net>
next in thread | raw e-mail | index | archive | help
Hi all, I use a new box with 4GB RAM as a pgsql server. In pgsql, you can set the effective_cache_size to indicate the memory available to cache disk I/O. As "recommended", my box use 1300MB to shared buffers (IPC shared memory) and 2700 Mo to disk cache. If I look memory usage in top, it say: Mem: 1154M Active, 1911M Inact, 601M Wired, 112M Cache, 417M Buf, 148M Free So I think FreeBSD must be limited using memory to cache I/O disk by some sysctl variables but I don't know which ones. I'm a little bit confused with some posts I found in this ML :-/ If someone can help me, it will be great. Regards, -- Nicolas Haller
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20101228135940.GE2660>