Re: query plan optimizer bug

I did VACUUM ANALYZE, there is no effect.

XuYifeng

----- Original Message -----
From: Don Baccus <dhogaza(at)pacifier(dot)com>
To: xuyifeng <jamexu(at)telekbird(dot)com(dot)cn>; <pgsql-hackers(at)postgresql(dot)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(at)pacifier(dot)com>
> Nature photos, on-line guides, Pacific Northwest
> Rare Bird Alert Service and other goodies at
> http://donb.photo.net.
>