Tuning for PostGreSQL Database
Piotr
meritus at wp.pl
Wed Jul 30 07:35:54 PDT 2003
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
More information about the freebsd-performance
mailing list