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

Re: Performance of count(*)

From: Andreas Kostyrka <andreas(at)kostyrka(dot)org>
To: Mario Weilguni <mweilguni(at)sime(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org,"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 15:17:17
Message-ID: 20070322151714.GA11448@andi-lap.la.revver.com (view raw or flat)
Thread:
Lists: pgsql-performance
* Mario Weilguni <mweilguni(at)sime(dot)com> [070322 15:59]:
> 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...
Well, mysql claims InnoDB to be mvcc ;)

Andreas

In response to

Responses

pgsql-performance by date

Next:From: Tino WildenhainDate: 2007-03-22 15:31:39
Subject: Re: Performance of count(*)
Previous:From: Craig A. JamesDate: 2007-03-22 15:16:51
Subject: Re: Performance of count(*)

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