Re: Optimizer bug??

From: "Ismail Kizir" <ikizir(at)tumgazeteler(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Optimizer bug??
Date: 2004-05-24 19:22:47
Message-ID: 00f801c441c4$7f55c760$0100000a@bilmednot
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

> give us the result of these queries:
> SELECT COUNT(*) FROM articletbl;

268726 records, it takes 34169 ms. to compute this

> SELECT COUNT(*) AS c FROM articletbl WHERE
> mydate BETWEEN '2004-04-24' AND '2004-05-24';

18982 records, it takes 34249 ms. to compute this.

> SELECT COUNT(*) AS c FROM articletbl WHERE
> mydate = '2004-04-24';
850 records, it takes only 40 ms. to compute this.

It is evident that there is a problem here! Am I wrong??

Regards
Ismail Kizir

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sérgio Monteiro Basto 2004-05-24 20:32:43 Re: Big problem
Previous Message Ismail Kizir 2004-05-24 18:49:41 Re: Optimizer bug??