Re: [GENERAL] Optimizations for busy DB??

On Thu, 13 May 1999, Brian wrote:

> Would something like this be appropriate?
>
> /usr/bin/postmaster -B 256 -i -S -D/var/lib/pgsql -o -F -B 256 -S 1024
>
> or should -B just be in their once? in the postmaster setting?

Just once.  If you pass it back to a backend from the postmaster, the
postmaster handles the allocation as shared memory buffers.  Here's what
the man page for postgres says:

-B n_buffers
              If the backend is  running  under  the  postmaster,
              n_buffers  is  the  number of shared-memory buffers
              that the postmaster has allocated for  the  backend
              server processes that it starts.  If the backend is
              running standalone, this specifies  the  number  of
              buffers  to  allocate.   This value defaults to 64,
              and each buffer is 8k bytes.

I am assuming here, of course, that this didn't change betwen 6.3 and 6.4
(which is what I am using).

Brett W. McCoy
                                         http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
"A raccoon tangled with a 23,000 volt line today.  The results blacked
out 1400 homes and, of course, one raccoon."
        -- Steel City News