Re: Which is faster SQL or PL/PGSQL - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Which is faster SQL or PL/PGSQL
Date
Msg-id 200310201849.19668.dev@archonet.com
Whole thread Raw
In response to Re: Which is faster SQL or PL/PGSQL  (Joe Conway <mail@joeconway.com>)
Responses Re: Which is faster SQL or PL/PGSQL  (Joe Conway <mail@joeconway.com>)
List pgsql-sql
On Monday 20 October 2003 18:24, Joe Conway wrote:
> Richard Huxton wrote:
> > So - gain by not re-planning on every call, but maybe lose because your
> > plan is not so precise.
> >
> > Of course, any queries you build dynamically and run via EXECUTE will
> > have to be planned each time.
>
> This question gets even more complex in 7.4, where many simple SQL
> functions will get inlined, and library preloading is available to speed
> that first PL/pgSQL call.

What will be the effects of inlining? Does it mean the planner merges the 
function's plan into the larger query?

--  Richard Huxton Archonet Ltd


pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Scripting only the functions
Next
From: Peter Eisentraut
Date:
Subject: [postgres] Deutsche PostgreSQL-Mailingliste unter postgresql.org