Re: First set of OSDL Shared Mem scalability results, some

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: First set of OSDL Shared Mem scalability results, some
Дата
Msg-id 8438.1098628775@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: First set of OSDL Shared Mem scalability results, some  (Curt Sampson <cjs@cynic.net>)
Ответы Re: First set of OSDL Shared Mem scalability results, some  (Curt Sampson <cjs@cynic.net>)
Список pgsql-performance
Curt Sampson <cjs@cynic.net> writes:
> On Sat, 23 Oct 2004, Tom Lane wrote:
>> Seems to me the overhead of any such scheme would swamp the savings from
>> avoiding kernel/userspace copies ...

> Well, one really can't know without testing, but memory copies are
> extremely expensive if they go outside of the cache.

Sure, but what about all the copying from write queue to page?

>> the locking issues alone would be painful.

> I don't see why they would be any more painful than the current locking
> issues.

Because there are more locks --- the write queue data structure will
need to be locked separately from the page.  (Even with a separate write
queue per page, there will need to be a shared data structure that
allows you to allocate and find write queues, and that thing will be a
subject of contention.  See BufMgrLock, which is not held while actively
twiddling the contents of pages, but is a serious cause of contention
anyway.)

            regards, tom lane

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

Предыдущее
От: Curt Sampson
Дата:
Сообщение: Re: First set of OSDL Shared Mem scalability results, some
Следующее
От: "Rod Dutton"
Дата:
Сообщение: Queries slow using stored procedures