Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id ED5312E0044 for ; Thu, 17 Apr 2008 13:49:32 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 99040-02 for ; Thu, 17 Apr 2008 13:49:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outmail137063.authsmtp.net (outmail137063.authsmtp.net [62.13.137.63]) by developer.postgresql.org (Postfix) with ESMTP id C22932E0042 for ; Thu, 17 Apr 2008 13:49:29 -0300 (ADT) Received: from mail.authsmtp.com (mail.authsmtp.com [62.13.128.187]) by punt4.authsmtp.com (8.14.1/8.14.1/Kp) with ESMTP id m3HGnQbi080687; Thu, 17 Apr 2008 17:49:26 +0100 (BST) Received: from [192.168.0.3] (85-211-74-64.dyn.gotadsl.co.uk [85.211.74.64]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m3HGnPuF038027; Thu, 17 Apr 2008 17:49:25 +0100 (BST) Subject: Re: SQL Function Slowness, 8.3.0 From: Simon Riggs To: Tom Lane Cc: "Gavin M. Roy" , pgsql-performance@postgresql.org In-Reply-To: <21424.1208450472@sss.pgh.pa.us> 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> <21424.1208450472@sss.pgh.pa.us> Content-Type: text/plain Date: Thu, 17 Apr 2008 17:50:55 +0100 Message-Id: <1208451055.4259.358.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 3d06cdcb-0c9e-11dd-941c-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadRtFaQJbbElD HGQLW1xEUVp7XWp/ aQ8fZQBDYEtPQQJu Tk5NXVBXCwUmXB95 cUB+F29ydA1Genk+ ZENjXT5YCER8JhIu EFNURmRTeGZhPDQC WURZJB5UcAJLdhoR aVd4ByJDAzANdhEA MjUdGAoUCH1kEQAd bBwLJk4TRkBDJTo7 WBYPBi5rVR1DHGNr RyAn X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:932/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/242 X-Sequence-Number: 29735 On Thu, 2008-04-17 at 12:41 -0400, Tom Lane wrote: > 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). That's a better term. I did say "name obfuscator" but I can see how that was confusing, especially with the recent discussion on code obfuscation. Sorry about that. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com