This line works:
/usr/local/pgsql/bin/postmaster -N 32 -B 928 -i -S
-D/home/postgres/pgdev -o "-F -fs -S 4096"

Where as this line:

/usr/local/pgsql/bin/postmaster -N 32 -B 1024 -i -S
-D/home/postgres/pgdev -o "-F -fs -S 4096"

does not.

Any ideas? 
I have 256M of memory, RedHat Linux 7.0, CVS version of Postgres as of a
couple days ago.

-- 
http://www.mohawksoft.com

Sun, 24 Dec 2000 13:52:43 -0500
mlw <markw@mohawksoft.com>
Upper limit on number of buffers?
* mlw <markw@mohawksoft.com> [001224 18:06] wrote:
> This line works:
> /usr/local/pgsql/bin/postmaster -N 32 -B 928 -i -S
> -D/home/postgres/pgdev -o "-F -fs -S 4096"
> 
> Where as this line:
> 
> /usr/local/pgsql/bin/postmaster -N 32 -B 1024 -i -S
> -D/home/postgres/pgdev -o "-F -fs -S 4096"
> 
> does not.
> 
> Any ideas? 
> I have 256M of memory, RedHat Linux 7.0, CVS version of Postgres as of a
> couple days ago.

Giving us the exact reason it "doesn't work" would be helpful, perhaps
the error message?

I'm just going to guess that you need to consult your OS's
documentation and figure out how to raise the amount of system V
shared memory available.

-- 
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

Sun, 24 Dec 2000 19:04:03 -0800
Alfred Perlstein <bright@wintelcom.net>
Re: Upper limit on number of buffers?
> * mlw <markw@mohawksoft.com> [001224 18:06] wrote:
> > This line works:
> > /usr/local/pgsql/bin/postmaster -N 32 -B 928 -i -S
> > -D/home/postgres/pgdev -o "-F -fs -S 4096"
> >
> > Where as this line:
> >
> > /usr/local/pgsql/bin/postmaster -N 32 -B 1024 -i -S
> > -D/home/postgres/pgdev -o "-F -fs -S 4096"
> >
> > does not.
> >
> > Any ideas?
> > I have 256M of memory, RedHat Linux 7.0, CVS version of Postgres as of a
> > couple days ago.
>
> I'm just going to guess that you need to consult your OS's
> documentation and figure out how to raise the amount of system V
> shared memory available.

I think Alfred is probably correct. I've run into this before myself. See
the following link:

http://www.postgresql.org/devel-corner/docs/admin/kernel-resources.htm#SYSVI
PC

The relevant section reads:

Linux

The default shared memory limit (both SHMMAX and SHMALL) is 32 MB in 2.2
kernels, but it can be changed in the proc file system (without reboot). For
example, to allow 128 MB:

$ echo 134217728 >/proc/sys/kernel/shmall
$ echo 134217728 >/proc/sys/kernel/shmmax
You could put these commands into a script run at boot-time.

Other parameters are sufficiently sized for any application. If you want to
see for yourself look into /usr/src/linux/include/asm-xxx/shmparam.h and
/usr/src/linux/include/linux/sem.h.

Hope this helps,

Joe



Sun, 24 Dec 2000 19:25:04 -0800
"Joe Conway" <jconway2@home.com>
Re: Upper limit on number of buffers?
/proc/sys/kernel/shmmax

	Oleg
On Sun, 24 Dec 2000, mlw wrote:

> Date: Sun, 24 Dec 2000 13:52:43 -0500
> From: mlw <markw@mohawksoft.com>
> To: Hackers List <pgsql-hackers@postgresql.org>
> Subject: [HACKERS] Upper limit on number of buffers?
> 
> This line works:
> /usr/local/pgsql/bin/postmaster -N 32 -B 928 -i -S
> -D/home/postgres/pgdev -o "-F -fs -S 4096"
> 
> Where as this line:
> 
> /usr/local/pgsql/bin/postmaster -N 32 -B 1024 -i -S
> -D/home/postgres/pgdev -o "-F -fs -S 4096"
> 
> does not.
> 
> Any ideas? 
> I have 256M of memory, RedHat Linux 7.0, CVS version of Postgres as of a
> couple days ago.
> 
> -- 
> http://www.mohawksoft.com
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Mon, 25 Dec 2000 07:47:58 +0300 (GMT)
Oleg Bartunov <oleg@sai.msu.su>
Re: Upper limit on number of buffers?
Oleg Bartunov wrote:
> 
> /proc/sys/kernel/shmmax

I think I am getting a lot of "Homer Simpson" awards this year. The
killer is that I have dealt with this problem on another project. Thanks
guys.
 

>         Oleg
> On Sun, 24 Dec 2000, mlw wrote:
> 
> > Date: Sun, 24 Dec 2000 13:52:43 -0500
> > From: mlw <markw@mohawksoft.com>
> > To: Hackers List <pgsql-hackers@postgresql.org>
> > Subject: [HACKERS] Upper limit on number of buffers?
> >
> > This line works:
> > /usr/local/pgsql/bin/postmaster -N 32 -B 928 -i -S
> > -D/home/postgres/pgdev -o "-F -fs -S 4096"
> >
> > Where as this line:
> >
> > /usr/local/pgsql/bin/postmaster -N 32 -B 1024 -i -S
> > -D/home/postgres/pgdev -o "-F -fs -S 4096"
> >
> > does not.
> >
> > Any ideas?
> > I have 256M of memory, RedHat Linux 7.0, CVS version of Postgres as of a
> > couple days ago.
> >
> > --
> > http://www.mohawksoft.com
> >
> 
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83

-- 
http://www.mohawksoft.com

Mon, 25 Dec 2000 18:26:51 -0500
mlw <markw@mohawksoft.com>
Re: Upper limit on number of buffers?