Re: 64-bit pgsql

-On [20030905 18:32], Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
>If it dies even at max_connections 10, that is a *lower* setting than we
>ever supported before (the pre-7.4 default was 32, and you need 20 or
>more to run the parallel regression test). I suspect that you actually
>don't have SysV semaphores enabled at all on that machine. There would
>be no point in trying any smaller values.

The SysV semaphores are enabled all right.

As comparison:

Itanium box running 5.1 | Athlon box running 4-STABLE

kern.ipc.msgmax: 16384 | kern.ipc.msgmax: 16384
kern.ipc.msgmni: 40 | kern.ipc.msgmni: 40
kern.ipc.msgmnb: 2048 | kern.ipc.msgmnb: 2048
kern.ipc.msgtql: 40 | kern.ipc.msgtql: 40
kern.ipc.msgssz: 8 | kern.ipc.msgssz: 8
kern.ipc.msgseg: 2048 | kern.ipc.msgseg: 2048
kern.ipc.semmap: 30 | kern.ipc.semmap: 30
kern.ipc.semmni: 10 | kern.ipc.semmni: 10
kern.ipc.semmns: 60 | kern.ipc.semmns: 60
kern.ipc.semmnu: 30 | kern.ipc.semmnu: 30
kern.ipc.semmsl: 60 | kern.ipc.semmsl: 60
kern.ipc.semopm: 100 | kern.ipc.semopm: 100
kern.ipc.semume: 10 | kern.ipc.semume: 10
kern.ipc.semusz: 104 | kern.ipc.semusz: 92
kern.ipc.semvmx: 32767 | kern.ipc.semvmx: 32767
kern.ipc.semaem: 16384 | kern.ipc.semaem: 16384
kern.ipc.shmmax: 67108864 | kern.ipc.shmmax: 33554432
kern.ipc.shmmin: 1 | kern.ipc.shmmin: 1
kern.ipc.shmmni: 192 | kern.ipc.shmmni: 192
kern.ipc.shmseg: 128 | kern.ipc.shmseg: 128
kern.ipc.shmall: 8192 | kern.ipc.shmall: 8192
kern.ipc.shm_use_phys: 0 | kern.ipc.shm_use_phys: 0

The same settings, except for kern.ipc.semusz and kern.ipc.shmmax, which
are higher than on my box running 7.3.4.

So it does seem 7.4 places higher demand than 7.3.4 on the SysV IPC,
since initdb also dies on my Athlon box which normally runs a PostgreSQL
7.3.4 database.

Like I said before, I am not certain if that was intentional, but if it
is a side effect of some change than the docs should emphasize that for
this release the SysV IPC dependencies might be a bit heavier than
7.3.4.

--
Jeroen Ruigrok van der Werven <asmodai(at)wxs.nl> / asmodai
PGP fingerprint: 2D92 980E 45FE 2C28 9DB7 9D88 97E6 839B 2EAC 625B
http://www.tendra.org/ | http://www.in-nomine.org/~asmodai/diary/
Believe those who are seeking the truth; doubt those who find it...