Re: Running postgresql/initdb on linux/parisc problem - Mailing list pgsql-admin

From Tom Lane
Subject Re: Running postgresql/initdb on linux/parisc problem
Date
Msg-id 29813.1047508117@sss.pgh.pa.us
Whole thread Raw
In response to Running postgresql/initdb on linux/parisc problem  (Guy Martin <gmsoft@gentoo.org>)
List pgsql-admin
Guy Martin <gmsoft@gentoo.org> writes:
> IpcSemaphoreCreate: semget(key=129, num=17, 03600) failed: No space left on
> device

I think the issue is that src/include/port/linux.h does not believe that
PARISC knows about test-and-set, so you're getting extra semaphores
being created (or trying to be created) to substitute for TAS spinlocks.
This is bad for performance, quite aside from the fact that you'd need
to boost the system's SEMMNI and/or SEMMNS to run Postgres that way.

Feel free to send in a patch that fixes it ;-).  There is code already
that implements TAS for PARISC under HPUX, but I'm not sure whether it'd
need any tweaking to make it compile under Linux.

            regards, tom lane

pgsql-admin by date:

Previous
From: Xue-Feng Yang
Date:
Subject: Re: Using functions as filters in queries
Next
From: "Stephane Charette"
Date:
Subject: flood of messages (was: Re: Using functions as filters in queries)