Re: 7.3.8 under FC3 takes excessive semaphores? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 7.3.8 under FC3 takes excessive semaphores?
Date
Msg-id 20210.1107189318@sss.pgh.pa.us
Whole thread Raw
In response to 7.3.8 under FC3 takes excessive semaphores?  ("Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk>)
Responses Re: 7.3.8 under FC3 takes excessive semaphores?  ("Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk>)
List pgsql-hackers
"Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk> writes:
> I'm trying to install a copy of PostgreSQL 7.3.8 on FC3 x86_64, and having a
> very strange problem with shared memory in that PostgreSQL seems to be
> taking far too many semaphores for the parameters in the postgresql.conf
> file.

Judging by the symptoms, you have built a version with what we now call
--disable-spinlocks; that is, it didn't figure out how to do assembly
TAS on your platform and fell back to using SysV semaphores for spinlocks.
Quite aside from the drain on semaphores, the performance is going to
be spectacularly bad, so you'd better fix that.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Group-count estimation statistics
Next
From: "Marc G. Fournier"
Date:
Subject: Bundles running late ...