Re: Memory requirments

The -B value is a a multiple of BLCKSZ, which is 8KB by default.

I would recommend using all availabe memory if it's a PostgreSQL
standalone box.

If your box has 256MB memory set the -B value to 200MB/8KB = 25600. Then
the OS will have 56MB. For a well configured Linux box, this should be
enough.

Remember to adjust the maximum shared memory value. On my Redhat Linux
7.0 box the vale is set in /proc/sys/kernel/shmmax.

This question has emerged more than once. Shouldn't we put it in the
FAQ?

Poul L. Christiansen

John Madden wrote:
>
> > But this scenario assumes that you have mostly SELECT queries.
> >
> > You have to remember to set the -B flag on postmaster to set the
> > shared-memory size.
>
> Any recommended values for -B, assuming a mostly-SELECT environment?
>
> John
>
> --
> # John Madden weez(at)freelists(dot)org ICQ: 2EB9EA
> # FreeLists, Free mailing lists for all: http://www.freelists.org
> # UNIX Systems Engineer, Ivy Tech State College: http://www.ivy.tec.in.us
> # Linux, Apache, Perl and C: All the best things in life are free!