From: | tgl(at)postgresql(dot)org (Tom Lane) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Arrange to "inline" SQL functions that appear in a query's FROM |
Date: | 2008-03-18 22:04:14 |
Message-ID: | 20080318220414.F402A7558DC@cvs.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Log Message:
-----------
Arrange to "inline" SQL functions that appear in a query's FROM clause,
are declared to return set, and consist of just a single SELECT. We
can replace the FROM-item with a sub-SELECT and then optimize much as
if we were dealing with a view. Patch from Richard Rowell, cleaned up
by me.
Modified Files:
--------------
pgsql/src/backend/catalog:
pg_proc.c (r1.148 -> r1.149)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_proc.c?r1=1.148&r2=1.149)
pgsql/src/backend/executor:
functions.c (r1.120 -> r1.121)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/functions.c?r1=1.120&r2=1.121)
pgsql/src/backend/optimizer/plan:
planner.c (r1.226 -> r1.227)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planner.c?r1=1.226&r2=1.227)
pgsql/src/backend/optimizer/prep:
prepjointree.c (r1.49 -> r1.50)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/prep/prepjointree.c?r1=1.49&r2=1.50)
pgsql/src/backend/optimizer/util:
clauses.c (r1.254 -> r1.255)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/clauses.c?r1=1.254&r2=1.255)
pgsql/src/include/executor:
functions.h (r1.30 -> r1.31)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/executor/functions.h?r1=1.30&r2=1.31)
pgsql/src/include/optimizer:
clauses.h (r1.88 -> r1.89)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/clauses.h?r1=1.88&r2=1.89)
prep.h (r1.59 -> r1.60)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/prep.h?r1=1.59&r2=1.60)
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2008-03-18 22:07:05 | Re: [COMMITTERS] pgsql: Enable probes to work with Mac OS X Leopard and other OSes that |
Previous Message | Heikki Linnakangas | 2008-03-18 21:54:30 | Re: Re: pgsql: Add URLs for : * Speed WAL recovery by allowing more than one |