Re: gprof SELECT COUNT(*) results

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: gprof SELECT COUNT(*) results
Дата
Msg-id 4389836D.8070501@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: gprof SELECT COUNT(*) results  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
> Thinking more about other systems, ISTM that Oracle can do this, as can
> any MVCC based system. OTOH DB2 and SQLServer take block level read
> locks, so they can do this too, but at major loss of concurrency and
> threat of deadlock. Having said that, *any* system that chose not to do
> this would be severely sub-optimal with buffer manager contention. So
> AFAICS they all need this optimization.

MySQL/Innodb would presumably do it also I wonder...

Chris


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

Предыдущее
От: Volkan YAZICI
Дата:
Сообщение: PQfnumber() Fix Proposal
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: Windows installation notes