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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
