Re: How Postgresql Compares For Query And Load Operations

> 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

I am surprised the others didn't optimize this more.  Seems they don't
keep an accurate count of the number of rows in a table either.  I
figured at least they would do an index scan for the count.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026