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

From Vadim Mikheev
Subject Re: [HACKERS] Re: [BUGS] General Bug Report: Bug in optimizer
Date
Msg-id 36F13C36.94170042@krs.ru
Whole thread Raw
In response to Re: [HACKERS] Re: [BUGS] General Bug Report: Bug in optimizer  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] Re: [BUGS] General Bug Report: Bug in optimizer
List pgsql-hackers
Bruce Momjian wrote:
> 
> > 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!
> 
> It is possible the new optimizer fixes this.  He needs to try the new
> snapshot to see.

vac=> create table table1 (field1 int);
CREATE
vac=> create index i_table1__field1 on table1 (field1);
CREATE
vac=> explain select * from table1 where field1 = 1;
NOTICE:  QUERY PLAN:

Index Scan using i_table1__field1 on table1  (cost=0.00 size=0 width=4)

Unfixed...

Vadim


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: [BUGS] General Bug Report: Bug in optimizer
Next
From: Zeugswetter Andreas IZ5
Date:
Subject: AW: [HACKERS] "CANNOT EXTEND" -