postmaster tuning commands - Mailing list pgsql-sql

From pierre
Subject postmaster tuning commands
Date
Msg-id 199812060436.EAA77864@out5.ibm.net
Whole thread Raw
List pgsql-sql
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

pgsql-sql by date:

Previous
From: "Ed Cox"
Date:
Subject: How can I return multiple rows from a FUNCTION? (revised)
Next
From: Jerome Knobl
Date:
Subject: Howto format a float8 number?