Tom Lane <tgl@sss.pgh.pa.us> wrote:=0A=0A> But having said that, it seems t=
hat this complaint implies that=0A> CREATE MATERIALIZED VIEW ... WITH NO DA=
TA still runs the query=0A> through a planning cycle.=A0 Why is that?=A0 I =
can't immediately see=0A> any benefit to doing so.=0A=0AWell, to be honest,=
it's because CREATE TABLE AS ... WITH NO DATA=0Adoes so, and I figured tha=
t if it was needed there I didn't see why=0ACREATE MATERIALIZED VIEW AS ...=
WITH NO DATA would be any=0Adifferent.=A0 I'm shameless in copying what se=
ems to be working.=0A=0A--=0AKevin Grittner=0AEDB: http://www.enterprisedb.=
com=0AThe Enterprise PostgreSQL Company