Re: Running postgresql/initdb on linux/parisc problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Guy Martin <gmsoft(at)gentoo(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Running postgresql/initdb on linux/parisc problem
Date: 2003-03-12 22:28:37
Message-ID: 29813.1047508117@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Guy Martin <gmsoft(at)gentoo(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephane Charette 2003-03-12 22:32:08 flood of messages (was: Re: Using functions as filters in queries)
Previous Message Xue-Feng Yang 2003-03-12 22:24:49 Re: Using functions as filters in queries