Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 05 Nov 2012 08:29:13 +0100
From:      Frank Broniewski <brfr@metrico.lu>
To:        freebsd-questions@freebsd.org
Subject:   Re: Why PostgreSQL doesn't start with shared_buffers=6GB ?
Message-ID:  <50976AC9.1010402@metrico.lu>
In-Reply-To: <50970E35.6000600@rawbw.com>
References:  <50970E35.6000600@rawbw.com>

next in thread | previous in thread | raw e-mail | index | archive | help
Hi,

I'm running Postgresql 9.1 on FreeBSD 9.0 with the following settings:

# postgresql.conf
shared_buffers = 8GB # pgtune wizard 2012-04-04

# /boot/loader.conf
kern.ipc.semmni=256
kern.ipc.semmns=512
kern.ipc.semmnu=256
kern.ipc.semumr=200
vm.pmap.shpgperproc=400
vm.pmap.pv_entry_max=50331648

# sysctl -a
kern.ipc.shm_allow_removed: 0
kern.ipc.shm_use_phys: 1
kern.ipc.shmall: 4189816
kern.ipc.shmseg: 128
kern.ipc.shmmni: 192
kern.ipc.shmmin: 1
kern.ipc.shmmax: 17161486336
kern.features.sysv_shm: 1
kern.features.posix_shm: 1


I hope that helps a little bit with value tuning,

Frank


Am 2012-11-05 01:54, schrieb Yuri:
> When I am setting shared_buffers=6GB in postgresql.conf it fails to start:
> DETAIL:  Failed system call was shmget(key=5432001, size=6612361216,
> 03600).
> even though kern.ipc.shmmax is set to ~7GB:
> $ sysctl -a | grep shm
> kern.ipc.shm_allow_removed: 0
> kern.ipc.shm_use_phys: 0
> kern.ipc.shmall: 1310720
> kern.ipc.shmseg: 128
> kern.ipc.shmmni: 192
> kern.ipc.shmmin: 1
> kern.ipc.shmmax: 7000000000
> kern.features.sysv_shm: 1
> kern.features.posix_shm: 1
>
> There are 17GB free memory as reported by top(1).
>
> Why shmget fails despite kern.ipc.shmmax is being high enough?
> Experimentally I found that shared_buffers=5GB also fails but 4GB
> succeeds. Is there another system limit on shmem besides kern.ipc.shmmax ?
>
> 9.1-RC3 and64
>
> Yuri
> _______________________________________________
> freebsd-questions@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to
> "freebsd-questions-unsubscribe@freebsd.org"
>


-- 
Frank BRONIEWSKI

METRICO s.à r.l.
géomètres
technologies d'information géographique
rue des Romains 36
L-5433 NIEDERDONVEN

tél.: +352 26 74 94 - 28
fax.: +352 26 74 94 99
http://www.metrico.lu



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?50976AC9.1010402>