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 

Piotr Rybicki

More information about the freebsd-performance mailing list