Re: Which is faster SQL or PL/PGSQL
| От | Richard Huxton |
|---|---|
| Тема | Re: Which is faster SQL or PL/PGSQL |
| Дата | |
| Msg-id | 200310201849.19668.dev@archonet.com обсуждение исходный текст |
| Ответ на | Re: Which is faster SQL or PL/PGSQL (Joe Conway <mail@joeconway.com>) |
| Ответы |
Re: Which is faster SQL or PL/PGSQL
|
| Список | 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 по дате отправления: