Configuration settings (shared_buffers, etc) in Linux: puzzled

Поиск
Список
Период
Сортировка
От Rick Schumeyer
Тема Configuration settings (shared_buffers, etc) in Linux: puzzled
Дата
Msg-id 4798D238.7070002@ieee.org
обсуждение исходный текст
Ответы Re: Configuration settings (shared_buffers, etc) in Linux: puzzled  (Greg Smith <gsmith@gregsmith.com>)
Re: Configuration settings (shared_buffers, etc) in Linux: puzzled  (Fernando Ike <fike@midstorm.org>)
Список pgsql-performance
On a linux box (Linux db1 2.6.18.8-md #1 SMP Wed May 23 17:21:37 EDT
2007 i686 GNU/Linux)
I edited postgresql.conf and changed:

shared_buffers = 5000           work_mem = 16384
max_stack_depth = 4096

and then restarted postgres.  The puzzling part is that postgres
actually started.  When I have done this on other boxes, I had to edit
kernel settings to allow for more shared memory.

The kernel settings are currently:

shmmax: 33554432
shmall: 2097152

I would have expected to need to increase these before postgres would run.

I have a nagging suspicion that something isn't right.  Like it's not
actually reading the conf file, or I might have a problem on reboot.

I'm not sure if I'm worrying about nothing, or if something weird is
going on.



В списке pgsql-performance по дате отправления:

Предыдущее
От: "Tory M Blue"
Дата:
Сообщение: Re: Postgres 8.2 memory weirdness
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Making the most of memory?