Re: Upper limit on number of buffers?
От | Joe Conway |
---|---|
Тема | Re: Upper limit on number of buffers? |
Дата | |
Msg-id | 035901c06e2a$062abd80$0705a8c0@jecw2k1 обсуждение исходный текст |
Ответ на | Upper limit on number of buffers? (mlw <markw@mohawksoft.com>) |
Ответы |
Re: Upper limit on number of buffers?
|
Список | pgsql-hackers |
> * 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 -N32 -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 raisethe 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 tosee for yourself look into /usr/src/linux/include/asm-xxx/shmparam.hand/usr/src/linux/include/linux/sem.h. Hope this helps, Joe
В списке pgsql-hackers по дате отправления: