Re: 7.3.8 under FC3 takes excessive semaphores?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7.3.8 under FC3 takes excessive semaphores?
Дата
Msg-id 20210.1107189318@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 7.3.8 under FC3 takes excessive semaphores?  ("Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk>)
Ответы Re: 7.3.8 under FC3 takes excessive semaphores?  ("Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Group-count estimation statistics
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Bundles running late ...