Re: Tuning for PostGreSQL Database

From: Piotr (meritus_at_wp.pl)
Date: 07/30/03

  • Next message: Pedram N: "FreeBSD 5.1 Server Crashed twice in 10 minutes." 
    To: freebsd-performance@freebsd.org
Date: Wed, 30 Jul 2003 16:35:49 +0200

    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

    _______________________________________________
    freebsd-performance@freebsd.org mailing list
    http://lists.freebsd.org/mailman/listinfo/freebsd-performance
    To unsubscribe, send any mail to "freebsd-performance-unsubscribe@freebsd.org"

  • Next message: Pedram N: "FreeBSD 5.1 Server Crashed twice in 10 minutes."