Re: A Guide to Constraint Exclusion (Partitioning)

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Uh, maybe you have sql_inheritance turned off? Every version I can
> remember would show you a pretty explicit Append plan for inheritance
> scans...

staging=> show sql_inheritance;
sql_inheritance
-----------------
on
(1 row)

Maybe I'm doing something more obvious wrong?

db=> create table _test (a integer);
CREATE TABLE

db=> create table _test2 (like _test);
CREATE TABLE

db=> create table _test3 (like _test);
CREATE TABLE

db=> create index _i on _test2 (a);
CREATE INDEX

db=> explain select * from _test where a=1;
QUERY PLAN
------------------------------------------------------
Seq Scan on _test (cost=0.00..22.50 rows=5 width=4)
Filter: (a = 1)
(2 rows)

--
greg