Re: Performance of count(*)

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, "Merlin Moncure" <mmoncure(at)gmail(dot)com>, "Andreas Tille" <tillea(at)rki(dot)de>
Subject: Re: Performance of count(*)
Date: 2007-03-22 14:36:32
Message-ID: 200703221536.32575.mweilguni@sime.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Am Donnerstag, 22. März 2007 15:33 schrieb Jonah H. Harris:
> On 3/22/07, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> > As others suggest select count(*) from table is very special case
> > which non-mvcc databases can optimize for.
>
> Well, other MVCC database still do it faster than we do. However, I
> think we'll be able to use the dead space map for speeding this up a
> bit wouldn't we?

Which MVCC DB do you mean? Just curious...

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ron 2007-03-22 14:37:04 Re: Lower Random Access Time vs RAID 0 / 1
Previous Message Jonah H. Harris 2007-03-22 14:33:29 Re: Performance of count(*)