Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXa1x-0007wN-6t for pgsql-sql@arkaria.postgresql.org; Tue, 08 Apr 2014 17:41:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WXa1w-0004Ya-LW for pgsql-sql@arkaria.postgresql.org; Tue, 08 Apr 2014 17:41:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXa1v-0004X3-5K; Tue, 08 Apr 2014 17:41:51 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXa1p-0004Bc-DR; Tue, 08 Apr 2014 17:41:50 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id s38Hfbrs019250; Tue, 8 Apr 2014 13:41:37 -0400 From: Tom Lane To: Gerardo Herzig cc: pgsql-performance@postgresql.org, pgsql-sql Subject: Re: Re: [PERFORM] performance drop when function argument is evaluated in WHERE clause In-reply-to: <34678100.310095.1396978407846.JavaMail.root@fmed.uba.ar> References: <34678100.310095.1396978407846.JavaMail.root@fmed.uba.ar> Comments: In-reply-to Gerardo Herzig message dated "Tue, 08 Apr 2014 14:33:27 -0300" Date: Tue, 08 Apr 2014 13:41:37 -0400 Message-ID: <19249.1396978897@sss.pgh.pa.us> X-Pg-Spam-Score: -2.2 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org Gerardo Herzig writes: > Tom, thanks (as allways) for your answer. This is a 9.1.12. I have to say, im not very happy about if-elif-else'ing at all. > The "conditional filter" es a pretty common pattern in our functions, i would have to add (and maintain) a substantial amount of extra code. In that case consider moving to 9.2 or later. I believe it'd handle this scenario better. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql