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