Received: from mx-30.mail.knowledge.com (office.knowledge.com [213.170.2.65]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f357TF881258 for ; Thu, 5 Apr 2001 03:29:17 -0400 (EDT) (envelope-from peter@office.knowledge.com) Received: from peter by mx-30.mail.knowledge.com with local (Exim 3.20 #1) id 14l4Cc-0006Fv-00; Thu, 05 Apr 2001 08:29:10 +0100 Date: Thu, 5 Apr 2001 08:29:10 +0100 From: Peter Galbavy To: Tom Lane Cc: pgsql-sql@postgresql.org Subject: Re: performance of functions - or rather lack of it Message-ID: <20010405082905.C25909@office.knowledge.com> References: <00bc01c0bcef$c527cf20$6601a8c0@knowledge.com> <7592.986403675@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <7592.986403675@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Wed, Apr 04, 2001 at 01:01:15PM -0400 X-Archive-Number: 200104/74 X-Sequence-Number: 2414 On Wed, Apr 04, 2001 at 01:01:15PM -0400, Tom Lane wrote: > Without knowing which PG version you're using, what plans you're > getting, or even whether you've VACUUM ANALYZEd lately, it's difficult > to say more than that. I followed that up quickly - server 7.0.2, client 7.1RC1. VACUUMed etc prior to the test. OTOH, since the tests were done multiple times directly after the other, the underlying infrastructure should be the same. BTW I deleted your paragraph above, but I agree about the parameters and the constant stuff. I will retry with a fixed-value function just for the completeness of it. > Unless your TCP connection is running across tin cans and string, > the transfer time for the query text is negligible ... Fair point. I am not really in the 100Mb networking work in my heart ... :-) -- Peter Galbavy Knowledge Matters Ltd http://www.knowledge.com/