Re: [GENERAL] Optimizations for busy DB?? - Mailing list pgsql-general

From Karl DeBisschop
Subject Re: [GENERAL] Optimizations for busy DB??
Date
Msg-id 199905131658.MAA02220@skillet.infoplease.com
Whole thread Raw
In response to Re: [GENERAL] Optimizations for busy DB??  (Brian <signal@shreve.net>)
Responses Re: [GENERAL] Optimizations for busy DB??
List pgsql-general
> it works.  Make sure you preface these backend options with -o, since the
> postmaster has its own options distinct from the backend.  Your complete
> invocation might look like
>
> postmaster -i -S -D/var/lib/pgsql -o -F -B 256 -S 1024

From the man page for postmaster:

       -o backend_options
            The  postgres(1) options specified in backend_options
            are passed to all backend server processes started by
            this  postmaster.   If the option string contains any
            spaces, the entire string must be quoted.


So therefore:

postmaster -i -S -D/var/lib/pgsql -o '-F -S 1024'

--
Karl DeBisschop <kdebisschop@spaceheater.infoplease.com>
617.832.0332 (Fax: 617.956.2696)

Information Please - your source for FREE online reference
http://www.infoplease.com  - Your Ultimate Fact Finder
http://kids.infoplease.com - The Great Homework Helper

pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: [GENERAL] Optimizations for busy DB??
Next
From: "Brett W. McCoy"
Date:
Subject: Re: [GENERAL] Optimizations for busy DB??