Martin Marques <martin@bugs.unl.edu.ar> writes:
> El Dom 16 Nov 2003 15:23, Tom Lane escribi�:
>> See sysctl. But what is the current value? I've never heard of a Linux
>> installation with small SEMVMX.
> martin@bugs:~/latex$ cat /proc/sys/kernel/sem
> 250 32000 32 128
> This is a Linux Kernel for SPARC (Debian) that came with the distribution (no
> recompile done yet here).
As far as I can tell, SEMVMX isn't readable or writable via /proc or
sysctl in Linux at all; at least it is not visible in my Red Hat 8.0
installation. So it's really hard to see why it'd be different in
your installation than everywhere else.
Just to make sure we're barking up the right tree, would you see whether
it helps to change this line in src/backend/port/sysv_sema.c:
#define PGSemaMagic 537 /* must be less than SEMVMX */
Try making it 100 or so instead of 537.
regards, tom lane