Re: BUG #8447: With table inheritance, indexes seems to be ignored when looking over indexed fields in base table - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #8447: With table inheritance, indexes seems to be ignored when looking over indexed fields in base table
Date
Msg-id 1378999186.30712.YahooMailNeo@web162902.mail.bf1.yahoo.com
Whole thread Raw
In response to BUG #8447: With table inheritance, indexes seems to be ignored when looking over indexed fields in base table  (stormbyte@gmail.com)
List pgsql-bugs
"stormbyte@gmail.com" <stormbyte@gmail.com> wrote:=0A=0A> [ Seq Scan is use=
d on empty relation, rather than Index Scan ]=0A=0A> This is not the expect=
ed result.=A0 [ ... ] it is still using=0A> sequential scan rather than wha=
t would be expected: Index Scan=0A=0AThis is not a bug.=0A=0AIf statistics =
indicate that all rows can be accessed with one page=0Aaccess (to the heap)=
 why should it use an index?=0A=0A--=0AKevin Grittner=0AEDB: http://www.ent=
erprisedb.com=0AThe Enterprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: laszlo.rozsahegyi@rool.hu
Date:
Subject: BUG #8448: looping through query results exits at 10th step under some conditions
Next
From: David Johnston
Date:
Subject: Re: BUG #8444: ERROR: table name "tblb" specified more than once in subquery