Re: gprof SELECT COUNT(*) results - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: gprof SELECT COUNT(*) results
Date
Msg-id 4389836D.8070501@familyhealth.com.au
Whole thread Raw
In response to Re: gprof SELECT COUNT(*) results  (Simon Riggs <simon@2ndquadrant.com>)
List 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 by date:

Previous
From: Volkan YAZICI
Date:
Subject: PQfnumber() Fix Proposal
Next
From: "Magnus Hagander"
Date:
Subject: Re: Windows installation notes