X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A4278D1B4ED for ; Fri, 14 Nov 2003 20:59:46 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 55314-10 for ; Fri, 14 Nov 2003 16:59:16 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id A1D5FD1B4EB for ; Fri, 14 Nov 2003 16:59:14 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hAEKxE19005188; Fri, 14 Nov 2003 15:59:14 -0500 (EST) To: "=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" Cc: pgsql-performance@postgresql.org Subject: Re: constant vs function param differs in performance In-reply-to: <01a601c3aac1$281e72c0$0403a8c0@fejleszt4> References: <01a601c3aac1$281e72c0$0403a8c0@fejleszt4> Comments: In-reply-to "=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" message dated "Fri, 14 Nov 2003 16:08:27 +0100" Date: Fri, 14 Nov 2003 15:59:14 -0500 Message-ID: <5187.1068843554@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/120 X-Sequence-Number: 4680 "=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" writes: > I have two SQL function that produce different times and I can't understand > why. The planner often produces different plans when there are constants in WHERE clauses than when there are variables, because it can get more accurate ideas of how many rows will be retrieved. regards, tom lane