Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group