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:[EMAIL PROTECTED] Sent: Thursday, March 08, 2007 12:50 PM To: Schwarz, Karl Cc: pgsql-performance@postgresql.org 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly