Re: Optimizer bug??

Поиск
Список
Период
Сортировка
От Ismail Kizir
Тема Re: Optimizer bug??
Дата
Msg-id 00f801c441c4$7f55c760$0100000a@bilmednot
обсуждение исходный текст
Ответ на Optimizer bug??  ("Ismail Kizir" <ikizir@tumgazeteler.com>)
Ответы Re: Optimizer bug??
Re: Optimizer bug??
Список 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

В списке pgsql-hackers по дате отправления: