X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 83C579DC88F for ; Sat, 17 Dec 2005 21:09:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 69133-01 for ; Sat, 17 Dec 2005 21:09:03 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id C70DD9DC849 for ; Sat, 17 Dec 2005 21:08:57 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 0CB14308DA; Sun, 18 Dec 2005 02:09:01 +0100 (MET) From: "Ben Trewern" X-Newsgroups: pgsql.performance Subject: Speed of different procedural language Date: Sun, 18 Dec 2005 01:10:21 -0000 Organization: Hub.Org Networking Services Lines: 14 Message-ID: X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2670 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-RFC2646: Format=Flowed; Original To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[AWL=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/523 X-Sequence-Number: 16344 I have a few small functions which I need to write. They will be hopefully quick running but will happen on almost every delete, insert and update on my database (for audit purposes). I know I should be writing these in C but that's a bit beyond me. I was going to try PL/Python or PL/Perl or even PL/Ruby. Has anyone any idea which language is fastest, or is the data access going to swamp the overhead of small functions? Thanks, Ben