Re: function performance vs in-line sql

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: function performance vs in-line sql
Дата
Msg-id 45F04CB5.4060204@archonet.com
обсуждение исходный текст
Ответ на function performance vs in-line sql  ("Schwarz, Karl" <Karl.Schwarz@ngc.com>)
Ответы Re: function performance vs in-line sql  ("Schwarz, Karl" <Karl.Schwarz@ngc.com>)
Список pgsql-performance
Schwarz, Karl wrote:
> Is there something basic I am missing here with the use of a function. I
> am no database expert, but my assumption was that a function would give
> me better results than in-line sql.

Not necessarily. Usually it means the planner has less information to go on.

We'll need more information though - table definitions, queries, how is
the function called etc.

--
   Richard Huxton
   Archonet Ltd

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Schwarz, Karl"
Дата:
Сообщение: function performance vs in-line sql
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: function performance vs in-line sql