Re: [GENERAL] Optimizations for busy DB??

> 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