Forum OpenACS Q&A: Re: postgresql startup script

Collapse
4: Re: postgresql startup script (response to 1)
Posted by Jon Griffin on 11/12/02 11:02 PM 

#!/bin/sh
exec 2>&1
exec setuidgid postgres /opt/pgsql/bin/postmaster -D /opt/pgsql/data -B 256 -N 128 -i
Collapse
5: Re: postgresql startup script (response to 4)
Posted by Jeff Davis on 11/12/02 11:14 PM
Jon, isn't that an awfully small number for -B?

I have been trying to figure out to tune postgres and the only rule of thumb I have seen for -B is to give it 1/4 of physical memory (or 16384 8k buffers for 512mb of memory).