Re: How Postgresql Compares For Query And Load Operations

From: Sean Chittenden <sean-pgsql-general(at)chittenden(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How Postgresql Compares For Query And Load Operations
Date: 2001-07-21 18:59:44
Message-ID: 20010721115944.T5160@rand.tgd.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > I thought it was worth trying a different query as well :
> >
> > SELECT count(*) FROM fact0
> >
> > DB Elapsed Cpu
> > Postgres 1m5s 32s
> > Db2 23s 15s
> > Oracle 37s 11s

This may be an Oracle DBA myth, but I was told by my ORA DBA
that it should be "SELECT count(1) FROM fact0" and not count(*). For
some reason it was thought that count(1) would run faster, but I can't
confirm or deny this. Does this make a difference in the benchmark?
-sc

--
Sean Chittenden

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Hansen 2001-07-21 20:15:24 foreign keys?
Previous Message Bruce Momjian 2001-07-21 18:27:55 Re: How Postgresql Compares For Query And Load Operations