Try this: http://www.powerpostgresql.com/Downloads/annotated_conf_80.html Peter L. Berghold wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Folks, I remember seeing somewhere a document that outlined how to tune memory for optimal operation of a postgres server on Linux. I can't seem to find that document again. I did fine one for the 7.x family but not 8.x and I'm currently running 8.x and noticing some heavy system load doing so. Any hints/tips appreciated on either where to look or how to tune this thing. Thanks, - -- :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: Peter L. Berghold Peter@xxxxxxxxxxxx "Those who fail to learn from history are condemned to repeat it." AIM: redcowdawg Yahoo IM: blue_cowdawg ICQ: 11455958 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCwrFqUM9/01RIhaARAowwAJ0WGG3iRjFn0AmaviMRgvjJpGMc5wCfUXlk 22RUTPMGOS8VLUl4nRZz7z0= =FKH1 -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
