Re: [BUGS] General Bug Report: Bug in optimizer

Vadim Mikheev <vadim@krs.ru>

From: Vadim Mikheev <vadim@krs.ru>
To: Andriy I Pilipenko <bamby@marka.net.ua>
Cc: hackers@postgresql.org
Date: 1999-03-18T16:29:56Z
Lists: pgsql-bugs, pgsql-hackers
Andriy I Pilipenko wrote:
> 
> Why I need to vacuum immediately after creating table?

Oh, sorry, I missed this -:)
Nevertheless, using index for 

select * from table1 where field1 = 1;

is bug!

> 
> Here is another example from live system:
> 
> statserv=> explain select * from ctime where ctg=-1;
> NOTICE:  QUERY PLAN:
> 
> Seq Scan on ctime  (cost=3646.86 size=8412 width=54)

As well as this one.
Should be fixed easy... Could someone address this? -:)

Vadim