Postgres Pro
Downloads
Home   >   mailing lists

Re: How Postgresql Compares For Query And Load Operations - Mailing list pgsql-general

From Bruce Momjian
Subject Re: How Postgresql Compares For Query And Load Operations
Date
Msg-id 200107211827.f6LIRtB27191@candle.pha.pa.us
Whole thread Raw
In response to Re: How Postgresql Compares For Query And Load Operations  (Mark kirkwood <markir@slingshot.co.nz>)
Responses Re: How Postgresql Compares For Query And Load Operations  (Sean Chittenden <sean-pgsql-general@chittenden.org>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: "Roderick A. Anderson"
Date:
Subject: Re: Language C - Console-based FrontEnd
Next
From: Sean Chittenden
Date:
Subject: Re: How Postgresql Compares For Query And Load Operations