Received: from out5.ibm.net (out5.ibm.net [165.87.194.243]) by hub.org (8.9.1/8.9.1) with ESMTP id XAA12187 for ; Sat, 5 Dec 1998 23:37:02 -0500 (EST) (envelope-from pierre@desertmoon.com) Received: from [129.37.118.75] (slip129-37-118-75.nc.us.ibm.net [129.37.118.75]) by out5.ibm.net (8.8.5/8.6.9) with SMTP id EAA77864 for ; Sun, 6 Dec 1998 04:36:55 GMT Message-Id: <199812060436.EAA77864@out5.ibm.net> Subject: postmaster tuning commands Date: Sat, 5 Dec 1998 22:36:55 -0600 x-mailer: Claris Emailer 2.0v3, January 22, 1998 From: pierre To: Mime-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Hi all...I'm trying to get the most optimal tuning parameters for my database..... Currently I'm using the following command line optinos to postmaster..... postmaster -B 128 -S -o -F -S 1024 None of the postgres processes last very long, but some of the queries can really chew on resources and disks.... What are some of the parameters people are using or have found to be the optimal? I'm running on bsdi 3.0...but am contemplating moving to one of the linux variants... -=pierre