Re: How Postgresql Compares For Query And Load Operations - Mailing list 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