Date: Wed, 30 Jul 2003 16:35:49 +0200 From: Piotr <meritus@wp.pl> To: freebsd-performance@freebsd.org Subject: Re: Tuning for PostGreSQL Database Message-ID: <200307301635.49791.meritus@wp.pl> In-Reply-To: <200307191818.13516.paul@pathiakis.com> References: <200307191818.13516.paul@pathiakis.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Dnia nie 20. lipca 2003 00:18, Paul Pathiakis napisał: > Hi, > Are there optimal parameters for sizing on the disk throughput? That is, > newfs parameters, i-node configuration, tunefs parameters, async on the > drives, etc? (consider nothing trivial, please feel free to just lay into > this like I'm a newbie - considering my not-so-extensive experience with > PostgreSQL) About newfs parameters i suggest to use: - block size = 8 Kb - fragment size = 8 Kb Setting theese parameters on database partition should minimize filesystem overhead since PostgreSQL stores it's database data in 8Kb chunks. But actually it's just a theory. I didn't make any test to proove the benefits. Regards Piotr Rybicki
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200307301635.49791.meritus>