Re: query plan optimizer bug

From: Don Baccus <dhogaza(at)pacifier(dot)com>
To: "xuyifeng" <jamexu(at)telekbird(dot)com(dot)cn>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: query plan optimizer bug
Date: 2000-11-22 02:51:07
Message-ID: 3.0.1.32.20001121185107.02213af0@mail.pacifier.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mitch Vincent 2000-11-22 03:12:33 Re: Crash during WAL recovery?
Previous Message xuyifeng 2000-11-22 02:46:49 query plan optimizer bug