RE: Performance TODO items

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: Performance TODO items
Дата
Msg-id 3705826352029646A3E91C53F7189E320166F9@sectorbase2.sectorbase.com
обсуждение исходный текст
Ответ на Performance TODO items  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
> New TODO entries are:
> 
>     * Order duplicate index entries by tid

In other words - add tid to index key: very old idea.

>     * Add queue of backends waiting for spinlock

We shouldn't mix two different approaches for different
kinds of short-time internal locks - in one cases we need in
light lmgr (when we're going to keep lock long enough, eg for IO)
and in another cases we'd better to proceed with POSIX' mutex-es
or semaphores instead of spinlocks. Queueing backends waiting
for spinlock sounds like nonsense - how are you going to protect
such queue? With spinlocks? -:)

Vadim


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Performance TODO items
Следующее
От: Bill Studenmund
Дата:
Сообщение: Re: SIGCHLD handler in Postgres C function.