Re: [BUGS] General Bug Report: Bug in optimizer - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: [BUGS] General Bug Report: Bug in optimizer
Date
Msg-id 36F12A04.1D6739BE@krs.ru
Whole thread Raw
In response to Re: [BUGS] General Bug Report: Bug in optimizer  (Andriy I Pilipenko <bamby@marka.net.ua>)
Responses Re: [HACKERS] Re: [BUGS] General Bug Report: Bug in optimizer
List 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


pgsql-hackers by date:

Previous
From: Andriy I Pilipenko
Date:
Subject: Re: [BUGS] General Bug Report: Bug in optimizer
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: [BUGS] General Bug Report: Bug in optimizer