Re: query plan optimizer bug

Поиск
Список
Период
Сортировка
От xuyifeng
Тема Re: query plan optimizer bug
Дата
Msg-id 001901c05447$ae7e5520$f5c2823d@xyf
обсуждение исходный текст
Ответ на Re: query plan optimizer bug  (Don Baccus <dhogaza@pacifier.com>)
Список pgsql-hackers
I did VACUUM ANALYZE, there is no effect.

XuYifeng

----- Original Message ----- 
From: Don Baccus <dhogaza@pacifier.com>
To: xuyifeng <jamexu@telekbird.com.cn>; <pgsql-hackers@postgresql.org>
Sent: Wednesday, November 22, 2000 10:51 AM
Subject: Re: [HACKERS] query plan optimizer bug


> At 10:46 AM 11/22/00 +0800, xuyifeng wrote:
> >Hi,
> >
> >it's obviously there is a query plan optimizer bug, if int2 type used in
> fields,
> >the plan generator just use sequence scan, it's stupid
> 
> Have you checked this with real data after doing a VACUUM ANALYZE?
> 
> 
> 
> - Don Baccus, Portland OR <dhogaza@pacifier.com>
>   Nature photos, on-line guides, Pacific Northwest
>   Rare Bird Alert Service and other goodies at
>   http://donb.photo.net.
> 


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

Предыдущее
От: Don Baccus
Дата:
Сообщение: Re: Crash during WAL recovery?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Crash during WAL recovery?