Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id A9B442E0042 for ; Thu, 17 Apr 2008 13:41:37 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 90126-03 for ; Thu, 17 Apr 2008 13:41:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by developer.postgresql.org (Postfix) with ESMTP id 129A42E0054 for ; Thu, 17 Apr 2008 13:41:31 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m3HGfCvI021425; Thu, 17 Apr 2008 12:41:12 -0400 (EDT) To: Simon Riggs cc: "Gavin M. Roy" , pgsql-performance@postgresql.org Subject: Re: SQL Function Slowness, 8.3.0 In-reply-to: <1208449557.4259.331.camel@ebony.site> References: <8328.1208358587@sss.pgh.pa.us> <1208448751.4259.317.camel@ebony.site> <20970.1208448770@sss.pgh.pa.us> <1208449557.4259.331.camel@ebony.site> Comments: In-reply-to Simon Riggs message dated "Thu, 17 Apr 2008 17:25:57 +0100" Date: Thu, 17 Apr 2008 12:41:12 -0400 Message-ID: <21424.1208450472@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/241 X-Sequence-Number: 29734 Simon Riggs writes: > On Thu, 2008-04-17 at 12:12 -0400, Tom Lane wrote: >> Aren't these suggestions mutually contradictory? > No, they're orthogonal. The pretty printer would get the indenting and > line feeds correct, the obfuscator would replace actual names with "A", > "B" or "Table1" etc.. Hmm, that's not what I'd call an "obfuscator", more an "anonymizer". Code obfuscators are generally intended to make code unreadable (in fact de-pretty-printing is one of their chief techniques). regards, tom lane