Re: function performance vs in-line sql

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Schwarz, Karl" <Karl(dot)Schwarz(at)ngc(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: function performance vs in-line sql
Date: 2007-03-08 17:49:41
Message-ID: 45F04CB5.4060204@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2007-03-08 17:52:34 Re: function performance vs in-line sql
Previous Message Schwarz, Karl 2007-03-08 16:24:16 function performance vs in-line sql