X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 50C9FD1E8BC for ; Thu, 22 Jan 2004 17:11:29 +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 18768-08 for ; Thu, 22 Jan 2004 13:10:58 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 37A87D1D4AE for ; Thu, 22 Jan 2004 13:10:57 -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 i0MHAupH012834; Thu, 22 Jan 2004 12:10:57 -0500 (EST) To: pginfo Cc: "pgsql-performance@postgresql.org" Subject: Re: Trigger performance In-reply-to: <400FECD6.B835AF9C@t1.unisoftbg.com> References: <400F9955.3C0FD784@t1.unisoftbg.com> <12241.1074785874@sss.pgh.pa.us> <400FECD6.B835AF9C@t1.unisoftbg.com> Comments: In-reply-to pginfo message dated "Thu, 22 Jan 2004 16:31:34 +0100" Date: Thu, 22 Jan 2004 12:10:56 -0500 Message-ID: <12833.1074791456@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/219 X-Sequence-Number: 5393 pginfo writes: > In wich case will this trigger work faster if write it in "C"? Given that the dominant part of the time will be spent down inside SPI in either case, I doubt you will be able to see much difference. You need to think about how to optimize the invoked query, not waste your time recoding the wrapper around it. regards, tom lane