Re: BUG #3495: PostgreSQL does not use POSIX SHM or SEM in place of SYSV equivalents - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3495: PostgreSQL does not use POSIX SHM or SEM in place of SYSV equivalents
Date
Msg-id 16662.1185658178@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #3495: PostgreSQL does not use POSIX SHM or SEM in place of SYSV equivalents  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-bugs
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> Roger Leigh wrote:
>> PostgreSQL is using the old SYSV shared memory and semaphores, as evidenced
>> by ipcs:

> A patch to do that submitted was submitted in Spring, but it was not
> accepted for 8.3 because there was some issues with it.

More strongly: it never will be accepted because the POSIX API doesn't
offer the features we need.

You can use POSIX semaphores if you choose (there are compile options
for that), but experience to date says that that degrades performance.
POSIX shared memory is simply not happening.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3495: PostgreSQL does not use POSIX SHM or SEM in place of SYSV equivalents
Next
From: Michał Niklas
Date:
Subject: Re: BUG #3493: Cannot find data with = operator