Re: function performance vs in-line sql - Mailing list pgsql-performance

From Richard Huxton
Subject Re: function performance vs in-line sql
Date
Msg-id 45F04CB5.4060204@archonet.com
Whole thread Raw
In response to function performance vs in-line sql  ("Schwarz, Karl" <Karl.Schwarz@ngc.com>)
Responses Re: function performance vs in-line sql
List 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 by date:

Previous
From: "Schwarz, Karl"
Date:
Subject: function performance vs in-line sql
Next
From: Heikki Linnakangas
Date:
Subject: Re: function performance vs in-line sql