Starting PostgreSQL 8.0.4 with more memory [FreeBSD 6.0]

Поиск
Список
Период
Сортировка
От Vlad
Тема Starting PostgreSQL 8.0.4 with more memory [FreeBSD 6.0]
Дата
Msg-id cd70c6810510301930g38750ffbtc247368853c12326@mail.gmail.com
обсуждение исходный текст
Ответы Re: Starting PostgreSQL 8.0.4 with more memory [FreeBSD 6.0]  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

I'm looking for some help in regards to letting Posresql use more
memory. It fails to start with this message:

shmat(id=65536) failed: Cannot allocate shared bufers

Max buffers I can start it with is 115200. Server has 4gig of RAM,
I've adjuted MAXDSIZ to 2.5Gigs. Here is other kernel settings

kern.ipc.shmall: 7000000
kern.ipc.shmseg: 8192
kern.ipc.shmmni: 8291
kern.ipc.shmmax: 2000000000
kern.ipc.semaem: 100000
kern.ipc.semvmx: 32767
kern.ipc.semusz: 332
kern.ipc.semume: 384
kern.ipc.semopm: 300
kern.ipc.semmsl: 300
kern.ipc.semmnu: 384
kern.ipc.semmns: 384
kern.ipc.semmni: 384
kern.ipc.semmap: 384

postgresql.conf:

shared_buffers = 152000         # min 16, at least max_connections*2, 8KB each
work_mem = 50000                # min 64, size in KB
maintenance_work_mem = 40000    # min 1024, size in KB
max_stack_depth = 6048          # min 100, size in KB
max_fsm_pages = 2000000         # min max_fsm_relations*16, 6 bytes each
max_fsm_relations = 28192       # min 100, ~50 bytes each

and there is no limits on pgsql user.

any help / ideas will be appreciated

--
Vlad

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

Предыдущее
От: "Florian G. Pflug"
Дата:
Сообщение: Re: Oracle 10g Express - any danger for Postgres?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Starting PostgreSQL 8.0.4 with more memory [FreeBSD 6.0]