Thread

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

Vadim Mikheev <vadim@krs.ru> — 1999-03-18T16:29:56Z

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