Thanks. I was not looking for help with the query just wanted to know that I didn't overlook some basic configuration setting. Karl -----Original Message----- From: Richard Huxton [mailto:dev@xxxxxxxxxxxx] Sent: Thursday, March 08, 2007 12:50 PM To: Schwarz, Karl Cc: pgsql-performance@xxxxxxxxxxxxxx Subject: Re: [PERFORM] function performance vs in-line sql 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
