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(at)spaceheater(dot)infoplease(dot)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