| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tino Wildenhain | 2007-03-22 15:31:39 | Re: Performance of count(*) |
| Previous Message | Craig A. James | 2007-03-22 15:16:51 | Re: Performance of count(*) |