Re: How Postgresql Compares For Query And Load Operations

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Mark kirkwood <markir(at)slingshot(dot)co(dot)nz>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: How Postgresql Compares For Query And Load Operations
Date: 2001-07-21 18:27:55
Message-ID: 200107211827.f6LIRtB27191@candle.pha.pa.us
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

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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sean Chittenden 2001-07-21 18:59:44 Re: How Postgresql Compares For Query And Load Operations
Previous Message Roderick A. Anderson 2001-07-21 17:02:46 Re: Language C - Console-based FrontEnd