Re: View's plan not taking advantage of WHERE?

On Wed, Jun 5, 2013 at 6:01 AM, Mike Summers <msummers57@gmail.com> wrote:
> From what I'm reading the View is frozen when it's created, including it's
> plan, and the usual solution is to use a set returning function... is this
> not true?

No it is not.  Here:

smarlowe=# create table a (id int);
CREATE TABLE
smarlowe=# create index a_id on a(id);
CREATE INDEX
smarlowe=# insert into a values (1),(2),(3);
INSERT 0 3
smarlowe=# create view x as select * from a;
CREATE VIEW

smarlowe=# analyze a;
ANALYZE
smarlowe=# show enable_seqscan;
 enable_seqscan
----------------
 on
(1 row)
smarlowe=# explain select * from x where id=1;
                   QUERY PLAN
-------------------------------------------------
 Seq Scan on a  (cost=0.00..1.04 rows=1 width=4)
   Filter: (id = 1)
(2 rows)

smarlowe=# set enable_seqscan =off;
SET
smarlowe=# explain select * from x where id=1;
                          QUERY PLAN
--------------------------------------------------------------
 Index Scan using a_id on a  (cost=0.00..8.27 rows=1 width=4)
   Index Cond: (id = 1)
(2 rows)

smarlowe=#

> I've double checked all schemas and the view is only defined once.

Well you're gonna have to come up with some kind of self-contained
test to show what's happening then.