Re: A Guide to Constraint Exclusion (Partitioning)

Tom Lane <tgl@sss.pgh.pa.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