| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: gprof SELECT COUNT(*) results |
| Date: | 2005-11-27 09:59:09 |
| Message-ID: | 4389836D.8070501@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Volkan YAZICI | 2005-11-27 12:02:51 | PQfnumber() Fix Proposal |
| Previous Message | Marc G. Fournier | 2005-11-27 02:25:02 | Developer vServer going down for maintenance ... |