| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | Alex Satrapa <alex(at)lintelsys(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org, Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Was: Triggers, Stored Procedures, PHP |
| Date: | 2003-12-01 00:23:00 |
| Message-ID: | 3FCA89E4.8030503@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Alvaro Herrera wrote:
> Me too. I've created many functions to extract data that are joined to
> other functions. All in all the result is not as optimal as it could
> be, because the optimizer can not poke into the functions, and the
> estimates about functions are only guesses. If one could use
> parametrized views instead of functions the whole mess would probably be
> more optimal.
>
How is a "parameterized view" any different than a set returning SQL
function? In either case, you've got the same work to do to teach the
optimizer how to understand it, no? Seems like the todo is just that,
teach the optimizer how to do better with set-returning SQL functions.
Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-12-01 00:33:17 | Re: Upgrading from 7.2.3 to....?? |
| Previous Message | Alvaro Herrera | 2003-11-30 23:42:53 | Re: Was: Triggers, Stored Procedures, PHP |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-12-01 04:06:55 | Wrong masklen in result of netmask()/hostmask() |
| Previous Message | Alvaro Herrera | 2003-11-30 23:42:53 | Re: Was: Triggers, Stored Procedures, PHP |