postmaster tuning commands

From: pierre <pierre(at)desertmoon(dot)com>
To: <pgsql-sql(at)postgreSQL(dot)org>
Subject: postmaster tuning commands
Date: 1998-12-06 04:36:55
Message-ID: 199812060436.EAA77864@out5.ibm.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Jerome Knobl 1998-12-07 07:59:44 Howto format a float8 number?
Previous Message Ed Cox 1998-12-06 00:35:13 How can I return multiple rows from a FUNCTION? (revised)