Date: Fri, 25 Jul 2003 14:25:57 -0400 From: "Michael E. Conlen" <meconlen@obfuscated.net> To: "Christopher Weimann" <cweimann@k12hq.com> Cc: freebsd-performance@freebsd.org Subject: RE: Tuning for PostGreSQL Database Message-ID: <FGEGKFPBILMAPHFOHIIFEECPDPAA.meconlen@obfuscated.net> In-Reply-To: <20030725162601.GA35378@smtp.k12us.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Usually a database server will have better algorithms to cache information than the OS, as the OS handles the general case, and the server can handle the specific case. In this case, I'd look to the Postgress people to see if they know which is better, but there's also this tidbit found on the page under the first link "There is one way to decide what is best for you. Set a high value of this parameter and run the database for typical usage. Watch usage of shared memory using ipcs or similar tools. A recommended figure would be between 1.2 to 2 times peak shared memory usage. " Give it a run and see. -- Michael Conlen -----Original Message----- I was concerned about the disk cache because of this link http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html#shbuf which says... PostgreSQL counts a lot on the OS to cache data files and hence does not bother with duplicating its file caching effort. The shared buffers parameter assumes that OS is going to cache a lot of files and hence it is generally very low compared with system RAM. Even for a dataset in excess of 20GB, a setting of 128MB may be too much, if you have only 1GB RAM and an aggressive-at-caching OS like Linux. But now that I have looked a bit more I see that this link http://www.postgresql.org/docs/aw_pgsql_book/hw_performance/node6.html which says... Ideally, the POSTGRESQL shared buffer cache will be: * Large enough to hold most commonly-accessed tables * Small enough to avoid swap pagein activity So I have conflicting documentation. I have machine with 4Gig of ram. What is the maximum value of SHMMAX on FreeBSD?
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?FGEGKFPBILMAPHFOHIIFEECPDPAA.meconlen>